Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
enolalum
 
Posts: n/a
Default mail merge using Word and Excel doesn't work correctly

In Office XP Professional, using Excel 2002 spreadsheet as data source for
Word 2002 letter merge worked many times before and now doesn't. The zip code
field changes from 5-9 digits to zero in about 1/3 of the letters. Remaining
2/3 of letters merge correctly. The zip codes that change are not just those
with a zero at the beginning of the 5-9 digits. Some of the 9 digits zip
codes change to zero now but didn't previously.

If I use a previously saved version of the spreadsheet, the merge prints out
correctly. However, if I make changes to the spreadsheet, some of the zip
code fields print as zero again. I have been using a version of the letter
and spreadsheet for over a year without any problems, until now.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
cannot mail merge from excel to word Alan Mailmerge 3 October 26th 05 05:03 AM
Mail Merge of a Date from Excel Data into Microsoft Word Keith A Microsoft Word Help 2 August 31st 05 05:01 AM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM


All times are GMT +1. The time now is 01:41 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"