Email as PDF attachment for multiple recipients

Hi all,

I would like to be able to attach a worksheet as a pdf in outlook based whether a checkbox is selected for that sheet. I have attached a basic model of what I would like to accomplish. There are five sheets for five customers each with an different email address. I would like to select which ones will get an email, press a button to email them and generate the separate email for each with their respective sheet as a pdf attachment.

Your help is always appreciated.

Ken

http://www.rondebruin.nl/win/s1/outlook/mail.htm

Thank you BellyGas for getting me started.

I have uploaded the excel file with code that generates a pdf attachment and generates an email in Outlook. What I need now is help with modifying the code to fit my needs.

The code looks for an email address in Cell A1 on every sheet and will email that sheet if A1 has an email address. What I need it to do is look at SHEET "Dashboard" and if Column "E" is TRUE and there is an email address in Column "C" then generate the email for that respective sheet.

I have tried unsuccessfully to create a loop that looks for both of these things, but made little progress.

I appreciate any help you can offer.

Thank you.
Ken

Hi all,

I'm trying to figure this out and could really use some help.

Here is what I have thus far.

Please Login or Register  to view this content.

The problem is it loops through and creates an email with attachment for every sheet. I need it to look at COLUMN "E" to check for TRUE and COLUMN "C" to check for an email address and then only create email with attachment for sheets listed in respective COLUMN "B".

Your help is greatly appreciated.

Ken

Excellent fix John. I am very grateful.
Ken

John,

A follow-up question if I may.

If the section:

Please Login or Register  to view this content.

I changed the StrBody to:

Please Login or Register  to view this content.

At home this works great, when I came to work today to check it, it doesn't put the contents of ("J2") in the body of the email. Any thoughts?
At home I use Office 2013 and at work it is Office 2010
Ken

Hey John,
update...tried again at home and it places the value of J2 in the body of the email. At work, no dice.

Ken

I will assume it has something to do with a network policy then. I appreciate your help. Take care.
Ken