#1
|
|||
|
|||
Pull information from 2 different rows in mail merge
I am trying to create a mail merge that will allow me to merge from multiple rows. For example:
«merge from row 1 Joe Bob» would like to buy from «merge from row 2 Kelly» land in the amount of $100. «merge from row 1 Joe Bob» agrees to pay «merge from row 2 Kelly» by money ordered mailed to «merge from row 2 Kelly's addresss» and so on. Every thread I've read only creates multiple documents with information from one row. Thanks. |
#2
|
||||
|
||||
Except where the grouping of data from multiple rows according to a common criterion is concerned, that is how mailmerges are designed to work.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Mail Merge
Is it possible that I'm not understanding the grouping process? I need information from the first row to populate and information from the second row to populate in the same document. I've attached what I hope is clear example.
|
#4
|
||||
|
||||
Your document doesn't employ grouping. For information about that, see, for example: https://www.msofficeforums.com/mail-...-tutorial.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Still Lost
Will grouping allow me to do what I'm trying to?
|
#6
|
||||
|
||||
I doubt it. You need to have all fields relating to the same record on one line.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
So there is not a way to pull data from multiple rows in mailmerge?
|
#8
|
||||
|
||||
You could use a NextRecord field, but I doubt that will give you the results you want, as all mergefields after the NextRecord field will point to the Next Record. There is no PreviousRecord field that might allow you to return to the original record.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
||||
|
||||
if you're willing, the following macro will reformat your worksheet so that it can work with a standard mailmerge:
Code:
Sub ReformatData() Application.ScreenUpdating = False Dim r As Long With ActiveSheet .Columns("A:H").Copy .Paste Destination:=.Range("I1") .Range("I2:P2").Delete Shift:=xlUp For r = .UsedRange.Cells.SpecialCells(xlCellTypeLastCell).Row To 3 Step -2 .Rows(r).EntireRow.Delete Next End With Application.ScreenUpdating = True End Sub So that the mailmerge can access the data correctly, all you'll need to do is to rename the column headers so they correctly differentiate buyers from sellers.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
mail merge, microsoft word 2013 |
|
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 | djrexy | Mail Merge | 1 | 05-20-2020 04:04 PM |
Need help suppressing information in a table in a mail merge | Laura123 | Mail Merge | 1 | 12-04-2017 01:34 PM |
Can you mail merge information into Smartart graphics? | QCJen | Word | 0 | 05-31-2017 08:02 AM |
How to mail merge information in PPT 2010 | mschlagel | Excel | 1 | 11-08-2012 07:49 PM |
Pull Outlook Meeting Information into Word | alhare | Word | 0 | 02-01-2011 12:51 PM |