Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Idaho, USA
    Thanked 0 Times in 0 Posts

    Mail merger using Excel data (Word/Excel 2003 SP1)

    A user in our agency was doing a mail merge in Word using an Excel data source. Some of the data source was updated to split the zip codes into two columns (5-digit and 4 supplemental digits) Some of the zip codes had a formula checker indicator(green triangle) in the cells when data was changed. When the labels were created, some labels had zero for the zip code. When checking further, the zero zip codes were the cells that display the formula checker. All cells in the zip code column were formatted as general yet some sent zero to the merge. When tested on Excel 2003 and Word 2003 without SP1, the merge ran without a problem. Can anyone give me an explanation of this phenonmenon? Thanks..Carol

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 30 Times in 30 Posts

    Re: Mail merger using Excel data (Word/Excel 2003 SP1)

    We'd have to see a sample of the data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts