View Single Post
 
Old 05-20-2020, 10:24 AM
djrexy djrexy is offline Windows 10 Office 2016
Novice
 
Join Date: May 2020
Posts: 1
djrexy is on a distinguished road
Lightbulb 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,
Attached Images
File Type: jpg EXCEL-2JPG.JPG (118.5 KB, 13 views)
Attached Files
File Type: xlsx Inspection Notes 20.09.XXX NAME.xlsx (38.2 KB, 7 views)

Last edited by djrexy; 05-20-2020 at 10:28 AM. Reason: uploaded files
Reply With Quote