Email from Excel and add attachement

G

Guest

I have a list of email recipients in Excel to which I would like to send an
email and add a PDF attachment. How can I create a new email, add the
respective recipients (email addresses in Excel and contact folder) from the
list in Excel and add the PDF attachment that corresponds to the recipient
list?

I would like to eventually, create a loop for several different attachments
that adds the respective recipients.

An example is as follows (list in Excel):

PDF1 goes to Joe Blow, Suzzy Know-it-All
PDF2 goes to Suzzy Know-it-All, Ima Duffas

Thanks for all your help!
-Chad
 
M

Michael Bauer

Hi Chad,

please search some samples in the VBA-help for Outlook and Excel:

Outlook:
- CreateItem(olMailItem)
- Recipients.Add
- Attachments.Add
- MailItem.Send

Excel:
- Workbooks.Open
- Range.Offset
- Range.Value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automate email and attach excel worksheet or workbook 3
XmlTextReader - finding attributes and then children. 2
email created with VB won't send 1
export email recipient addresses to excel 3
Add Hyperlink in Email 4
Import Outlook excel attachement 2
Sending message with multiple SMTP BCCs 2
email from excel cell 1

Top