Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    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
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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
  •