Labels Mail Merge Issue 'new record' blank

B

bristolbanter

I have gone through all the normal steps.

The data source is an excel spreadsheet and is correctly identified.

When I look at the recipient list they are all there in order.

All the necessary fields are matched.

However, the <<new record>> field that is automatically entered for eac
label pulls off no information. The sheets preview as blank.

I have tested it by entering <<addressblock>> elsewhere on the sheet
This works and inserts the information from the excel spreadsheet bu
obviously only one individual per sheet because it no longer thinks it'
doing labels but a letter.

I am using the latest version of both word and excel

please hel
 

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
580
Reaction score
50
What kind of mailmerge are you trying to do? Your post seems to indicate a mix of labels and letters, which can't be done from a single mailmerge main document.
 
Top