Pull information from 2 different rows in mail merge

macropod · #9 05-05-2021, 11:14 PM

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

After the macro has been run, you'll see that every second row has been moved to columns I:P.

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.

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