Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2012, 05:22 PM
Claytocb Claytocb is offline How to add attachment to email merge Windows 7 64bit How to add attachment to email merge Office 2010 64bit
Novice
How to add attachment to email merge
 
Join Date: Sep 2012
Posts: 5
Claytocb is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-07-2012, 07:47 PM
macropod's Avatar
macropod macropod is offline How to add attachment to email merge Windows 7 64bit How to add attachment to email merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See: http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-12-2012, 03:16 PM
Claytocb Claytocb is offline How to add attachment to email merge Windows 7 64bit How to add attachment to email merge Office 2010 64bit
Novice
How to add attachment to email merge
 
Join Date: Sep 2012
Posts: 5
Claytocb is on a distinguished road
Default

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!
Reply With Quote
  #4  
Old 09-12-2012, 04:34 PM
macropod's Avatar
macropod macropod is offline How to add attachment to email merge Windows 7 64bit How to add attachment to email merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #5  
Old 09-12-2012, 05:03 PM
Claytocb Claytocb is offline How to add attachment to email merge Windows 7 64bit How to add attachment to email merge Office 2010 64bit
Novice
How to add attachment to email merge
 
Join Date: Sep 2012
Posts: 5
Claytocb is on a distinguished road
Default

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!
Reply With Quote
  #6  
Old 09-12-2012, 06:02 PM
macropod's Avatar
macropod macropod is offline How to add attachment to email merge Windows 7 64bit How to add attachment to email merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

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
How to add attachment to email merge 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
How to add attachment to email merge Forwarding email with attachment braindead Outlook 2 01-14-2010 06:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft