Excel and Mail Merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using an excel document to create a mail merge in word. I am having problems with my zip codes. My document reflects the correct mailing address, but when merging, any zip code that starts with a "Zero", the zero is dropped, thus an incomplete zip code. I have changed my the formulas in my cells using every option available, I have deleted the address and re-entered it, and I have also created a new document but I still get the same results. Anyone have any suggestions?
 
Debra Dalgleish posted this:

In the Mail Merge, 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 will be retained.

If you have to connect through a different source, you can format the
fields in the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document


=======
And David McRichie usually posts a followup:
use a helper column in excel and make the zipcodes text and use that in your
import:

=text(a1,"00000")
 
Back
Top