Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-20-2020, 10:24 AM
djrexy djrexy is offline Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge Windows 10 Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge Office 2016
Novice
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge
 
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, 7 views)
Attached Files
File Type: xlsx Inspection Notes 20.09.XXX NAME.xlsx (38.2 KB, 3 views)

Last edited by djrexy; 05-20-2020 at 10:28 AM. Reason: uploaded files
Reply With Quote
  #2  
Old 05-20-2020, 04:04 PM
macropod's Avatar
macropod macropod is online now Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge Windows 7 64bit Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,216
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

That is not possible with mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail, merge, transpose

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge 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 with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge Mail Merge fields merge incorrectly and won't fix. marym Mail Merge 3 04-09-2016 05:17 AM
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge 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
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft