Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cockatiel's mom
 
Posts: n/a
Default Word 2003 Mail Merge from Excel spreadsheet database

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Word 2003 Mail Merge from Excel spreadsheet database

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_lab...th_word_xp.htm



--
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

"Cockatiel's mom" Cockatiel's wrote in
message ...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
Word 2003, mail merge disabled when doc opened in Internet Explore LSiKevin Mailmerge 0 July 14th 05 08:24 PM
Word Mail Merge using Excel data HT New Users 3 July 14th 05 12:28 PM
Word 2003 SP1 mail merge data issue Richard W Mailmerge 2 May 16th 05 10:31 PM
Exchange 2003 - Outlook 2003 - Word 2003 mail merge Micheline Mailmerge 1 December 2nd 04 11:51 AM


All times are GMT +1. The time now is 05:28 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"