Link to home
Create AccountLog in
Avatar of auraorange
auraorangeFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Merging fields into text boxes - Data duplicates

I have a spreadsheet from Excel 2003 and run a mail merge each week with new data using merged fields to place this data into Word 2003.

Due to image resizing issues within Word 2003 I have had to use a text box for some information to be merged into.

The merge displays details of 3 different properties on each page but the text box duplicates the 3 sets of image information on each page incorrectly

We have a similar document that shows details of only 1 property per page and this works fine so I was hoping to work out some code that tells the information which text box to go to.

I have attached 3 files:

1) Excel 2003 Data File
2) Mergedfields Word 2003 Document Template
3) Output File
XML-Extract-example.xls
-MASTER--Merged-Doc-Template-x3.doc
X3-Example-Output.doc
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of auraorange

ASKER

Thank you very much!

Worked perfectly