Email Spreadsheet with Outlook Macro

[chriswathen]

I am using this code below to generate a copy of my spreadsheet and email it to someone. When I run this code, it will display 4 email windows (all the exact same), how to I correct this? I have also tried to use the .Send instead of .Display but outlook pops up and says "A program is trying to send an e-mail on your befalf.......ect" and when I click allow, excel thinks it didn't work and keeps trying to send over and over and over until I deny and end the macro.

Please Login or Register  to view this content.

Thanks,
Chris

[jaslake]

Hi Chris

I'd think it's because you have 4 worksheets...comment out those lines of code.

Please Login or Register  to view this content.

[chriswathen]

I do have a total of 4 worksheets in this workbook. How would I make it only send the one spreadsheet "RR Tracker"?

[jaslake]

Hi Chris

Comment out the indicated lines of code...see what happens.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[chriswathen]

Perfect. Thank you!

[jaslake]

You're welcome...glad I could help.