Take data from multiple rows in a word/excel mail merge?

A

Anon

Hi,

I have a Mail Merge document in Word taking data from an Excel
spreadsheet. Is there a way for a Merge Field to take data from two
different records? For instance, I want a mergefield to take the data
from one cell, and antoher mergefield to take the data from the cell
below it. For example:


My Excel Document:
A B
1 firstrecord data1
2 secondrecord data2


My Word Document:

First Record Data: <<data1>>
Second Record Data: <<data2>>


Say I want to have <<data1>> take the contents of cell B1 and
<<data2>> to take the contents of cell B2.

Any help would be greatly appreciated.

-Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Populate One Pages from spreadsheet 0
Auto Merge text from multiple sources 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Merging from an Excel file with graphics 1
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Dates In Excel 5
Integrating information from Word to Excel (not mail merge) 1

Top