Word 2003 Mail Merge from Excel spreadsheet database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cockatiel's mom - 02 Jan 2006 03:27 GMT

I recently upgraded to Word 2003. I am using a template and an Excel
database which I have used before to mail merge labels. However, when I
select the database for merging in Word 2003, I get the following options:
OLE Database Files
Excel Worksheet via Converter
MS Excel Worksheets via DDE
Excel Files via ODBC

I have been selecting converter, because i don't know what any of the others
mean. However, the final merge document is only one page, even though all
258 names on the spreadsheet are selected. Can anyone help? Why can't I use
the spreadsheet in its original form as I was able to do in Word 2000.
Thanks.

Reply to this Message

Doug Robbins - Word MVP - 02 Jan 2006 04:44 GMT

The problem is that you have not actually executed the merge, but are merely
viewing/printing a preview of the result.

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

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 recently upgraded to Word 2003. I am using a template and an Excel
> database which I have used before to mail merge labels. However, when I
[quoted text clipped - 11 lines]
> the spreadsheet in its original form as I was able to do in Word 2000.
> Thanks.

Reply to this Message