#1
|
|||
|
|||
How to add attachment to email merge
Need to know how to include a PDF attachment in an email merge from word. In other words I am creating the email in a word doc and using the new list function of mail merge to bring in certain fields. How do I include a separate attachment to the emails I am sending via mail merge?
I am not referring to inserting a hyperlink as those accessing outside the organization would not be able to access. Thanks |
#2
|
||||
|
||||
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks Macropod
I have set the reference From within ms word to the ms outlook object library and created a macro based on the code provided. I also created a two column table in word and filled it with data from my data source(excel) and sent it to a directory type document using the mail merge function. I saved this doc. I went back to my original mail merge doc that I want to email, used the same data source and pulled in the fields i needed merged. I ran the macro from within this mail merge doc and was able to select the doc with my table that contained the email and attachment from the data source. It runs but says " 0 messages sent" Am I on the right track? Any suggestions? Thanks so much for your help! |
#4
|
||||
|
||||
Hi Claytocb,
I'm not clear on what you're doing. In your first post, you mentioned "using the new list function of mail merge to bring in certain fields". I am not aware of any such functionality that has been added to Word 2010. Are you using a 3rd-party add-in of some kind?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
My apologies macropod. I was using the create new list in the mail merge portion of word however I am no longer utilizing that. No third party plugin. My datasource is now an excel spreadsheet that contains 4 fields that I merge into my main mail merge email document. It also contains the email addresses and the file path of the attachment. (So This is also the same source I am using in the table that your instructions say to create. I just merge in the email and attachment fields in the table)
Normally if I were not trying to attach anything I would just merge in my fields from excel ( source ) into the email merge document and then just execute the emails from there. I assume since the macro is created I no longer use the finish and merge option in word as I would have if I were not attaching anything.I just let the macro run and send the maul merge doc with the attachment? Thanks again for all of your help! |
#6
|
||||
|
||||
Once you've done the preliminaries in the link I provided (which includes executing a Directory/Catalog merge), the 'emailmergewithattachments' macro should take care of the rest.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge with attachment | vijanand1279 | Word | 3 | 11-22-2011 12:52 PM |
Printing a sent email with attachment | Karen Rose | Outlook | 0 | 05-20-2011 03:28 AM |
email as pdf attachment - subject line and attachment named after mail merge | Nexus | Mail Merge | 12 | 04-13-2011 11:34 PM |
Merge Fields, Pictures and output to email (with attachment) | schilds71 | Mail Merge | 0 | 10-21-2010 12:02 PM |
Forwarding email with attachment | braindead | Outlook | 2 | 01-14-2010 06:03 PM |