The 'Update All Labels' button has nothing to do with the connection method, so I'm not surprised changing the former had no effect on the latter.



Previews are not a reliable indicator of the final output - to see what will print, send the output to a new document.

Without actually seeing the problem mailmerge main document and source data, it can be difficult for anyone to diagnose the issue. Can you attach the document to a post with some sample data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks Paul. I'm not sure how to send the output to a new document. I've attached the page with «Next Record»«AddressBlock», may not work without the spreadsheet attached?

Attached Files

1 AddressBlock.doc (36.0 KB, 12 views)