Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-09-2017, 10:09 AM
mrjimi mrjimi is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2017
Posts: 2
mrjimi is on a distinguished road
Post Include multiple (but varying in number) Excel rows in each separate email

I have the data below in Excel format (also attached). I want to send one email to Ralph, one email to Mary, one email to Jack, and one email to Tina. Each email has to include a table or list that tells each employee their Rating for each of their Tasks. As you can see, not every employee has the same Tasks or same number of Tasks. It's important that each employee receive only a single email.

Sorry if this has already been answered, but I could not find a thread that was exactly on point. Thanks!

Recipient Email Your Tasks Your Rating
Ralph ralph@company.com Tooth brushing 4


Ralph ralph@company.com Car washing 5
Ralph ralph@company.com Lawn mowing 2
Ralph ralph@company.com Pie eating 3
Ralph ralph@company.com Nose picking 5
Mary mary@company.com Car washing 5
Mary mary@company.com Fence jumping 1
Jack jack@company.com Letter typing 5
Jack jack@company.com Pie eating 3
Jack jack@company.com Tooth brushing 1
Tina tina@company.com Car washing 4
Tina tina@company.com Fence jumping 4
Tina tina@company.com Tooth brushing 3
Tina tina@company.com Nose picking 5
Attached Files
File Type: xlsx Sample spreadsheet.xlsx (8.7 KB, 4 views)
Reply With Quote
  #2  
Old 12-09-2017, 09:30 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,725
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

This is a many to one mail merge - see http://www.gmayor.com/ManyToOne.htm

See also http://www.msofficeforums.com/mail-m...ps-tricks.html
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 12-10-2017, 03:11 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,394
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

See also: https://answers.microsoft.com/en-us/...f-8642e46fa103. The same DATABASE field approach can be used for an email merge. For a non-mailmerge DATABASE field demonstration, see: http://www.msofficeforums.com/mail-m...html#post67097
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 12-10-2017, 09:45 AM
mrjimi mrjimi is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2017
Posts: 2
mrjimi is on a distinguished road
Default Thanks, all

I'll try the add-on!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to separate number in excel yoyo4 Excel 1 11-21-2017 09:46 AM
Email Merge: Is It Possible to Include Multiple rows (Excel) of data with For Each Record Emailed? Sgt Rock Mail Merge 6 08-10-2016 11:03 AM
Include header and footer formatting when using IF conditional includes of separate documents anakaine Mail Merge 3 11-06-2015 09:51 PM
Add multiple rows to Excel 2010 table at cursor position C J Squibb Excel Programming 12 11-07-2013 07:35 AM
Moving data from multiple rows to 1 row for each program number ballj_35 Excel 3 08-01-2012 05:10 AM


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