Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-30-2023, 02:48 PM
Alimilne Alimilne is offline Email mail merge? Windows 10 Email mail merge? Office 2019
Novice
Email mail merge?
 
Join Date: Jan 2023
Posts: 1
Alimilne is on a distinguished road
Default Email mail merge?

Hi there,



I'm currently running what is in effect a monthly Speed Dating project, but for business purposes (!). The matches are created through an Excel spreadsheet which will generate c75 pairings each month which are sent out to a mass distribution list. Given the numbers involved, it can be a lengthy email and isn't very user-friendly.

What I'm looking to do is to be able to email a set email template to each pairing, however, ideally would automate this rather than 75 separate emails. Is this something that can be done through a mail merge?
Reply With Quote
  #2  
Old 01-31-2023, 01:35 AM
JamesMWood JamesMWood is offline Email mail merge? Windows 10 Email mail merge? Office 2021
Novice
 
Join Date: May 2022
Posts: 25
JamesMWood is on a distinguished road
Default

As far as I know, the built-in email merge is very limited, where you can only send to one recipient at a time. So you'd have to put your 'pairs' actually on separate rows, and they'd get separate emails. Your actual template would be done in Word, and you then load your data in there, add the merge fields from your data, and then send the email merge through Word; FYI it will only send from your default Outlook email account. Hope this gives you some direction
Reply With Quote
  #3  
Old 02-02-2023, 10:50 PM
gmayor's Avatar
gmayor gmayor is offline Email mail merge? Windows 10 Email mail merge? Office 2019
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

You may be able to use E-Mail Merge Add-in to create your e-mail messages configured in a Word document.

If the data comprises consecutive pairs of records, you may be able to use Merge Many To One to create a many to one merge to e-mail.

All depends on how the data is configured.
__________________
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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Email lgsikaffy Mail Merge 1 07-11-2019 04:35 AM
Mail Merge won't email QEDDave Mail Merge 11 10-29-2014 09:44 PM
Mail Merge Many URLs in one email by common email address instantaphex Mail Merge 3 04-29-2013 05:46 PM
Mail Merge to email, changing images on email layout ginelli Mail Merge 18 02-23-2013 09:47 AM
Mail Merge via Proxy Email? ghillie30 Mail Merge 0 07-08-2011 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:02 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