Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-05-2021, 05:23 PM
NikiB0987 NikiB0987 is offline Pull information from 2 different rows in mail merge Windows 10 Pull information from 2 different rows in mail merge Office 2013
Novice
Pull information from 2 different rows in mail merge
 
Join Date: May 2021
Posts: 4
NikiB0987 is on a distinguished road
Unhappy 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.
Reply With Quote
  #2  
Old 05-05-2021, 06:31 PM
macropod's Avatar
macropod macropod is offline Pull information from 2 different rows in mail merge Windows 10 Pull information from 2 different rows in mail merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,215
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

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]
Reply With Quote
  #3  
Old 05-05-2021, 06:46 PM
NikiB0987 NikiB0987 is offline Pull information from 2 different rows in mail merge Windows 10 Pull information from 2 different rows in mail merge Office 2013
Novice
Pull information from 2 different rows in mail merge
 
Join Date: May 2021
Posts: 4
NikiB0987 is on a distinguished road
Default 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.
Attached Files
File Type: docx Test Master Merge 2.docx (12.9 KB, 1 views)
File Type: xlsx Test Master 2.xlsx (24.1 KB, 1 views)
Reply With Quote
  #4  
Old 05-05-2021, 06:52 PM
macropod's Avatar
macropod macropod is offline Pull information from 2 different rows in mail merge Windows 10 Pull information from 2 different rows in mail merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,215
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

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]
Reply With Quote
  #5  
Old 05-05-2021, 06:53 PM
NikiB0987 NikiB0987 is offline Pull information from 2 different rows in mail merge Windows 10 Pull information from 2 different rows in mail merge Office 2013
Novice
Pull information from 2 different rows in mail merge
 
Join Date: May 2021
Posts: 4
NikiB0987 is on a distinguished road
Default Still Lost

Will grouping allow me to do what I'm trying to?
Reply With Quote
  #6  
Old 05-05-2021, 06:54 PM
macropod's Avatar
macropod macropod is offline Pull information from 2 different rows in mail merge Windows 10 Pull information from 2 different rows in mail merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,215
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

I doubt it. You need to have all fields relating to the same record on one line.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 05-05-2021, 06:55 PM
NikiB0987 NikiB0987 is offline Pull information from 2 different rows in mail merge Windows 10 Pull information from 2 different rows in mail merge Office 2013
Novice
Pull information from 2 different rows in mail merge
 
Join Date: May 2021
Posts: 4
NikiB0987 is on a distinguished road
Default

So there is not a way to pull data from multiple rows in mailmerge?
Reply With Quote
  #8  
Old 05-05-2021, 07:24 PM
macropod's Avatar
macropod macropod is offline Pull information from 2 different rows in mail merge Windows 10 Pull information from 2 different rows in mail merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,215
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

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]
Reply With Quote
  #9  
Old 05-05-2021, 11:14 PM
macropod's Avatar
macropod macropod is offline Pull information from 2 different rows in mail merge Windows 10 Pull information from 2 different rows in mail merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,215
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

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge, microsoft word 2013

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull information from 2 different rows in mail merge 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
Pull information from 2 different rows in mail merge 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:12 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