Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-07-2018, 07:26 PM
llhark llhark is offline Windows 10 Office 2016
Novice
 
Join Date: May 2018
Posts: 1
llhark is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-08-2018, 05:25 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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:
http://www.msofficeforums.com/mail-m...-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:
http://www.msofficeforums.com/mail-m...-multiple.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 07-08-2018, 08:21 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,755
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

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)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

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


All times are GMT -7. The time now is 12:28 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft