Mail Merge not in same order as in XLS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phillip Vong - 21 Aug 2006 20:03 GMT

Using Office 2003.

A simple mail merge to creat lables. I have an excel sheet with Columns
(FirstName, LastName, Address). When I do a Mail Merge, the selection has
Address first and I want the merge selection to show in the exact same order
as I have it in Excel.

Thanks in advance.

Phil

Reply to this Message

Doug Robbins - Word MVP - 22 Aug 2006 04:32 GMT

I assume that you are using the AddressBlock and the fields are not mapped
correctly. Instead of doing that, just insert the individual merge fields
into the main document in the order that you want them.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Using Office 2003.
>
[quoted text clipped - 6 lines]
>
> Phil

Reply to this Message

Rate this thread: