Marco To Create PDF Using Specific Sheets & Attach To Outlook Email

[Gtrtim112]

Can anyone tell me why my macro isn't working properly?

The following code has been working flawlessly for quite some time but now it won't do as I need it to.

I want the macro to take specific sheets, create a PDF with them and attach the PDF file to an Outlook email. In this case, it's sheets 2, 3, 4 and 8. However, it will only attach the active sheet. I can't figure out why.

Please Login or Register  to view this content.

Thanks!

[Logit]

.

Please Login or Register  to view this content.

[Gtrtim112]

Thanks, Logit! I will give this a whirl in the morning and let you know if it works for me.

[Gtrtim112]

Actually, I just noticed something...

It doesn’t appear to have the code that would tell it where the email addresses are listed on one of the sheets. Look at my previous code and you’ll see they are listed in AA10 on a particular sheet.

Can you add that command into the code you offered?

.

Please Login or Register  to view this content.

[Logit]

.
Replace this line in the macro of the workbook I attached :

Please Login or Register  to view this content.

With this line :

Please Login or Register  to view this content.

Change the sheet names in these two lines to the sheet name where you have the command button to run the macro:

Please Login or Register  to view this content.

If the Command Button is located on Sheet 1 .... don't change it.