|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
||||
|
||||
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] |
#4
|
|||
|
|||
Thanks, all
I'll try the add-on!
|
|
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 |