#1
|
|||
|
|||
How do you Email Directory Merge?
Am trying to create a directory mail merge to be emailed. I maintain update info in excel spreadsheet that needs to be emailed out weekly to staff and many times same staff member have more than one update to review (hence needing directory merge). Also wanted to merge a picture with each item but am first trying to email a directory merge...then worry about the pictures.
Email always sends an email for each record (so one person can get 5 separate emails. I have completed a directory merge but just can't send by email. Please help. LP |
#2
|
||||
|
||||
A directory merge cannot be used with emailing. For a workaround, see Merging by Catalog/Directory to E-Mail in my Microsoft Word Catalogue/Directory Mailmerge Tutorial, in the 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...-tutorial.html Another option would be to use a DATABASE field in a normal ‘letter’ mailmerge main document and a macro to drive the process. An outline of this approach can be found at: http://answers.microsoft.com/en-us/o...1-1996c14dca5d Conversely, if you're using a relational database or, Excel workbook with a separate table with just a single instance of each of the grouping criteria, a DATABASE field in a normal ‘letter’ mailmerge main document could be used without the need for a macro. An outline of this approach can be found at: https://answers.microsoft.com/en-us/...f-8642e46fa103 For a working example, see: https://www.msofficeforums.com/mail-...-multiple.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
My old friend Greg Maxey is about to launch a version of a Many to One add-in for Windows which uses content controls to place the data. It includes an option to convert mail merge fields to content controls and will allow you to merge your data in a table to e-mail and include the graphics if you associate the file paths with the records. He is working on his web page, but that should take a few days to complete. It should be worth waiting.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
directory merge, directory merge email, email merge |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Directory Mail Merge for Donations | Andrewwill | Mail Merge | 7 | 09-21-2017 07:11 PM |
Directory Mail Merge | IslandAC | Mail Merge | 1 | 09-09-2016 04:53 PM |
Help with using catalog in Directory merge | tarcher61 | Mail Merge | 15 | 03-30-2016 02:08 PM |
Directory Mail Merge Trouble | Murph14 | Mail Merge | 5 | 06-03-2015 12:22 AM |
Directory Mail Merge Issues | dbpros_crm | Mail Merge | 10 | 01-20-2014 11:05 PM |