Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-27-2019, 06:58 AM
Catherine.DeMayo Catherine.DeMayo is offline Mail Merge Grouping Windows 10 Mail Merge Grouping Office 2013
Novice
Mail Merge Grouping
 
Join Date: Sep 2019
Posts: 1
Catherine.DeMayo is on a distinguished road
Default Mail Merge Grouping

I apologize if I amasking my question in the wrong formum. Anyway, I have a mail mergeproject. Mail merge standard emails I can handle no problem (at least Ithink). My question is I need to mail merge information to let's say anagent whose name is Desktop Agency. Desktop Agency has 5 overduereports due. My excel spreadsheet has 5 rows with a column for jobnumbers late and a column for Agent Name. Job numbers aredifferent. When I mail merge my emails, I end up with 5 different emailsas opposed to one email listing all 5 jobs which are late. How do Iachieve creating a merge to Desktop Agency listing all 5 jobs late in one emailrather than sending out 5 emails. Plus I need to use emails from a separate excel file. So, I will be using two spreadsheets to create one email (letter).

Attached Files
File Type: xls PastDueTest.xls (30.0 KB, 9 views)
Reply With Quote
  #2  
Old 09-28-2019, 08:11 PM
gmayor's Avatar
gmayor gmayor is offline Mail Merge Grouping Windows 10 Mail Merge Grouping 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

This is a many to one mail merge - see Merge Many To One
However you would have to create a worksheet that combines your worksheet with your mailmerge data and to use the above method you would not be able to leave column A empty.
__________________
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
  #3  
Old 09-30-2019, 09:39 PM
macropod's Avatar
macropod macropod is offline Mail Merge Grouping Windows 7 64bit Mail Merge Grouping 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

Another option would be to use a DATABASE field in a normal ‘email’ mailmerge main document and a macro to drive the process. An outline of this approach can be found at:
Many to one email merge using tables - Microsoft Community
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 ‘email’ mailmerge main document could be used without the need for a macro. An outline of this approach can be found at:
Mail Merge - To a Word Table on a Single Page - Microsoft Community
For some working examples (though not specifically for emails), see:
Mail Merge: Using One Excel File with Multiple Sheets
Merge excel list into Word Receipt
__________________
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 Grouping Word Merge Grouping spyldbrat Mail Merge 1 06-05-2019 05:43 PM
Total formula for mail merge grouping jackmp3 Mail Merge 3 10-22-2018 12:40 PM
Mail Merge Grouping Mail Merge Grouping Multiple Records into 1 Output DeniseStafiej Mail Merge 1 08-03-2018 03:41 PM
Mail Merge Grouping mail merge multiple rows within a grouping tracygleghorn Mail Merge 12 11-12-2015 06:43 AM
Mail Merge Grouping Grouping list in Mail Merge AlexTeslin Mail Merge 1 03-08-2013 09:31 PM

Other Forums: Access Forums

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