Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2018, 07:26 PM
llhark llhark is offline How do you Email Directory Merge? Windows 10 How do you Email Directory Merge? Office 2016
Novice
How do you Email Directory Merge?
 
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 How do you Email Directory Merge? Windows 7 64bit How do you Email Directory 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

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]
Reply With Quote
  #3  
Old 07-08-2018, 08:21 PM
gmayor's Avatar
gmayor gmayor is offline How do you Email Directory Merge? Windows 10 How do you Email Directory Merge? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
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) (2002-2019)
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
How do you Email Directory Merge? Directory Mail Merge for Donations Andrewwill Mail Merge 7 09-21-2017 07:11 PM
How do you Email Directory Merge? Directory Mail Merge IslandAC Mail Merge 1 09-09-2016 04:53 PM
How do you Email Directory Merge? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 AM.


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