Email Spreadsheet with Outlook Macro

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

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.

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.

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