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

Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Merging from an Excel file with graphics 1
Mail Merge Directory Conditional Page Break 0
Leading 0 in Mail Merge document 5
Grouping Names in Mail Merge 0
Zip codes in mail merge - first digit doesn't display in merge 1
Duplicate Mail Merge Record Every Time 5
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2

Top