Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2002
    Location
    Northwood Hills, Middlesex, England
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge (2003)

    I've been trying to create a mail merge from an Excel data source which includes a Calculated field using the a combination of if and isblank functions. It displays correctly in the spreadsheet, but when merged displays as zeros instead of blank. I can' t find guidance on formatting the word mergefields to eliminate the problem, am I missing something?

    Thanks

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

    Re: Mail Merge (2003)

    In Word, select Tools | Options...
    Activate the General tab.
    Tick the check box "Confirm conversion at Open".
    Click OK.

    Now go back to step 3 of the mail merge wizard (task pane).
    Click "Select a different list" and navigate to your Excel workbook.
    You'll be prompted to select a method to connect to the workbook.
    Instead of the default OLE DB, choose either "Microsoft Excel Worksheet via Converter" or "MS Excel Worksheets via DDE" and click OK.
    Proceed as usual.
    Blanks should now remain blanks in the merged document, instead of becoming zeros.

  3. #3
    New Lounger
    Join Date
    May 2002
    Location
    Northwood Hills, Middlesex, England
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (2003)

    Many thanks

  4. #4
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (2003)

    Thanks for this, Hans,
    I've just had a cognate problem and your fix worked (so far....)

Posting Permissions

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