Email worksheet as PDF and using cells within activesheet for email addresses

**Mosborne1** · 02-23-2011, 12:15 PM

I am very new to coding. I found coding to convert and email a worksheet in pdf format at http://www.rondebruin.nl/files/PDFExamples.txt. I need to email these files to a few different addresses within a range of cells. It is too cumbersome to have to hard code each sheet within the workbook with email addresses from the active sheet I am emailing. Each sheet goes to a different customer. this is the code I am using:

Please Login or Register  to view this content.

I found coding to email the worksheet to a range of addresses within the page, but havent' been successful in using it for the pdf coding.:

Please Login or Register  to view this content.

Thank you.

**Mosborne1** · 02-24-2011, 04:55 PM

"Still looking for help on this, any advice?"

**johnkubik** · 02-24-2011, 06:13 PM

I use this in my email macro. I have a Sheet called "Email List" and in column "F" of that sheet is an email address. I have it so when there is an 'x' in any of the column "A" it adds the email list to a variable q, with the correct ; to make it so you can add multiple addresses.

Please Login or Register  to view this content.

Oh yeah, the x adds it to the "to list" the c does the cc list.

If you want to see the semi-full macro look here...
http://www.excelforum.com/excel-prog...mac-macro.html

Hope this helps!