Excel database to mail merge

  • Thread starter Thread starter BobBlueJay
  • Start date Start date
B

BobBlueJay

I have our high school alumni database in an Excel (2002)
spreadsheet (6,000+ entries). I use this database and
mail merge in Word 2002 to make mailing labels. I have
some 5-digit zip codes and some zip code+4 in the
database. When I mail merge the zip code+4's come out
as "0". The 5 digit zip codes are fine. I successfully
mail merged labels from this database in the past but my
computer was hit by lightning 3 months ago. I installed
Excel and the database info into the new computer. I've
tried this with Word on two different computers with the
same results. Any suggestions?
 
In Word, after you select your Excel file as a data source, you should
see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your
formatting should be retained.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leading 0 in Mail Merge document 4
How do I format zip code (9) to use in Word merg doc 1
How to merge Excel address columns when some zips begin with zeros 4
Excel Help 2
only 5 digit zip codes 1
mail merge 2
zip codes become 0 after merge excel to word 1
How do I get leading zeros in zip codes in a mail merge 1

Back
Top