Mailmerge question

[Vicki13]

I am trying to produce index cards on card stock to do an inventory for a
High School Band. My information is in Excel. I have defined and named the
table. When I use mail merge wizard and I select my recipient from the Excel
document some of my information has been turned to "0". This occurs in the
Item # and Serial # column and appears to be the numbers that have a letter
or a dash in them. I have formatted the original Excel document cells to
Text so it shouldn't be confused. I have tried formating them as General as
well and that doesn't work. Any ideas on how I can accomplish this? I was
able to do it in the past. When I looked at that old Excel document those
cells had no document highlighted under Format cell. Any help would be
appreciated.

 

[Doug Robbins - Word MVP]

If using a version of Word before 2007, from the Tools menu, select Options
and then go to the General tab and check the box against the "Confirm
conversions at open." item. In Word 2007, click on the Office button and
then on Word Options and then on Advanced and scroll down to the General
section and check the box for "Confirm file format conversion at open"

After having done this, re-attach the data source to the mail merge main
document and when the dialog box appears asking for the method by which the
connection should be made, select the DDE option.

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