Excel database to mail merge

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

Debra Dalgleish

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

How to merge Excel address columns when some zips begin with zeros 4
Leading 0 in Mail Merge document 4
mail merge 2
Excel Help 2
only 5 digit zip codes 1
zip codes become 0 after merge excel to word 1
How do I format Zip codes to print properly in a Mail merge? 7
Zip code loses leading zero Mail Merge from Excel to Word Labels 1

Top