Email from Excel and add attachement

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top