Mailmerge with Excel spreadsheet switches columns to display

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SharronTucker - 09 Aug 2005 16:05 GMT

I have tried to mailmerge with an excel spreadsheet that has columns in order
of lastname,firstname,streetaddress1,streetaddress2,city,state,zip. When
word brings up the spreadsheet columns for me to pick which records I want to
merge, it has rearranged the columns to start with streetaddress1 and so
forth until the lastname and firstname are the last columns. This then
requires me to scroll to the end to see the name and then back to the check
box to check or uncheck the box to include the person in the mail merge. HELP

Reply to this Message

Doug Robbins - 09 Aug 2005 18:31 GMT

This might have something to do with the way Word is attaching the data
source. From the Tools menu, select Options and then go to the General tab
and check the box before "Confirm conversions at open" After doing that,
when you attach the data source, you will be prompted for the method of
connection to use. Try using the DDE option.

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

>I have tried to mailmerge with an excel spreadsheet that has columns in
>order
[quoted text clipped - 7 lines]
> box to check or uncheck the box to include the person in the mail merge.
> HELP

Reply to this Message