|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge
EXCEL-2JPG.JPG - Google Drive Typically a mail merge extracts data from an Excel table using the information in along a certain row as "recipients". Meaning along the same row I can input an unlimited number of COLUMNS from where I can extract the Fields. I did it successfully however I'd like to "TRANSPOSE" the Rows with Columns when it comes to Mail Merge. I would like to be able to perform a mail merge with the FIELDS extracted from Excel ROWS instead of the COLUMNS. So basically, TRANSPOSE the FIELDS with the COLUMNS and get just one individual document with multiple fields along Column B from the image above. 1) Is this possible? 2) If yes, how can I do it? Thank you, Last edited by djrexy; 05-20-2020 at 10:28 AM. Reason: uploaded files |
#2
|
||||
|
||||
That is not possible with mailmerge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
mail, merge, transpose |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I mail merge records into table columns with more than one merge field? | tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
Mail Merge fields merge incorrectly and won't fix. | marym | Mail Merge | 3 | 04-09-2016 05:17 AM |
trouble setting excel to import correctly into mail merge. Not using typical address fields | ragoo | Mail Merge | 1 | 10-28-2014 03:42 PM |
Mail merge how to link mail merge field value to a column heading | dsummers | Mail Merge | 1 | 05-08-2014 02:59 PM |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |