Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2017, 10:09 AM
mrjimi mrjimi is offline Include multiple (but varying in number) Excel rows in each separate email Windows 10 Include multiple (but varying in number) Excel rows in each separate email Office 2016
Novice
Include multiple (but varying in number) Excel rows in each separate email
 
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, 10 views)
Reply With Quote
  #2  
Old 12-09-2017, 09:30 PM
gmayor's Avatar
gmayor gmayor is offline Include multiple (but varying in number) Excel rows in each separate email Windows 10 Include multiple (but varying in number) Excel rows in each separate email 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 http://www.gmayor.com/ManyToOne.htm

See also https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
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 12-10-2017, 03:11 AM
macropod's Avatar
macropod macropod is offline Include multiple (but varying in number) Excel rows in each separate email Windows 7 64bit Include multiple (but varying in number) Excel rows in each separate email 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

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: https://www.msofficeforums.com/mail-...html#post67097
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 12-10-2017, 09:45 AM
mrjimi mrjimi is offline Include multiple (but varying in number) Excel rows in each separate email Windows 10 Include multiple (but varying in number) Excel rows in each separate email Office 2016
Novice
Include multiple (but varying in number) Excel rows in each separate email
 
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 multiple (but varying in number) Excel rows in each separate email Include header and footer formatting when using IF conditional includes of separate documents anakaine Mail Merge 3 11-06-2015 09:51 PM
Include multiple (but varying in number) Excel rows in each separate email 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 PM.


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