Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Christchurch, Canterbury
    Posts
    122
    Thanks
    27
    Thanked 1 Time in 1 Post

    Mailmerge Excel to Word broke after upgrade (2003)

    Hi, a mail merge has been working for yonks on XP. Source is an Excel file. Since moving to 2003 SOME fields now show as 0. They are specifically ones that "look" like a division eg 205/207. I have tried formatting them as text and putting in a single quote but it shows as 0. And now, if I edit any cell in that column (that I formatted as text) it also shows as 0. Any idea if there is a fix out there?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mailmerge Excel to Word broke after upgrade (2003)

    Try the following:
    - Select Tools | Options... in Word.
    - Activate the General tab.
    - Tick the check box "Confirm conversion at Open".
    - Click OK.
    - Activate the Mail Merge task pane, and go back to step 3.
    - Click 'Select a different list'.
    - Browse to your Excel workbook again, select it and click Open.
    - You'll be prompted to select a method to connect to the data source.
    - Select either "Microsoft Excel Worksheet via Converter" or "MS Excel Worksheets via DDE"
    - Do *not* select "OLE DB Data Files" or "Excel Files via ODBC".
    - Click OK, then proceed as usual.

    Post back if this doens't help.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Christchurch, Canterbury
    Posts
    122
    Thanks
    27
    Thanked 1 Time in 1 Post

    Re: Mailmerge Excel to Word broke after upgrade (2003)

    Brilliant - worked a treat. Thanks.

Posting Permissions

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