Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Portland, Maine, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge (Word 2002 (SP2))

    I am doing a merge document with selected Outlook contacts as the data source. I am initiating the merge from Outlook.

    I am using the the address block field to insert the name and address. All is well except contacts that have a two line address such as a street and a PO Box. When this occurs, I get a blank line between the street and city, state, zip lines. I have had the same results on 2-3 different machines with both SP1 and SP2 installed.

    Has anyone else seen this? Does anyone have an answer? It looks like a bug!

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Word 2002 (SP2))

    Hi Daryl:
    This is partly a guess because I don't have Word 2002. Have you checked for the option in mail merge to supress blank lines? Also, (since I don't use Outlook either <img src=/S/smile.gif border=0 alt=smile width=15 height=15>), when you look at the field codes, is there one for PO Box? If so, you might be able to replace that with an IF field:

    {IF {Mergefield POBox}<>"" {Mergefield POBox} "" }

    I may have the name of the mergefields wrong, but you get the idea.
    Cheers,

  3. #3
    Lounger
    Join Date
    Jul 2002
    Location
    Wellington, North Island, New Zealand
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Word 2002 (SP2))

    Hi Darryl,

    I found the same problem when merging to Word from VB software. I use the same document and it is fine in 97 and 2000 - it will suppress the blank lines but when I use Word 2002 it leaves the space where there are blank lines. So annoying. It does not matter if you turn the "suppress blank lines" option on or off it still does the same thing and leaves the lines in.

    I posted a mail a few weeks ago asking about this but I didn't get any replies. I am sorry you have the same problem but I am glad another user has seen this as it proves that its not just me.

    If anyone can shed any light on this I would be eternally grateful.

    JOTO

  4. #4
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Portland, Maine, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Word 2002 (SP2))

    The problem is that there are not any blank lines to suppress. The records with the blank line are the ones with an extra line in the address. In the process of creating the data source from Outlook, Word inserts a line return after the first address line AND after the second line of the address.

    One other issue with this "new and improved" mail merge. The address block is a nice feature so that I don't have to pick first name, last name, etc. However, it does not "match" the zip code field. You have to go into record matching and match the correct field.

    First, Word should be able to find the correct field in Outlook.
    Second, the zip code field is at the bottom of the list and the only way to get there is to scroll down.

  5. #5
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Portland, Maine, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Word 2002 (SP2))

    The two items in my last post on this topic look like bugs to me. 1. The extra line in the result. 2. Does not map the zip code field even though Outlook is the data source.

    Today I found another bug in the "new and improved" mail merge with Word 2002. My data source is Excel 2002. Whenever I have a number that ends in .33, the merge result is .330000000000002. This is not a calculated field. I even tried =round(.33,2) in Excel with the same result. I formatted the field in Excel as "text" - same result. I got around it by entering '.33. I could not duplicate this with Word 2000.

  6. #6
    New Lounger
    Join Date
    Aug 2001
    Location
    Dallas, Texas, Texas, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Word 2002 (SP2))

    I wanted to tell you I also have the same problem. I have two lines of an address and it's not suppressing the second return.

    Let me know if you hear of any "fix"

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Word 2002 (SP2))

    Have you tried using an IF field, as I described in <post#=195567>post 195567</post#>?

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Mail Merge (Word 2002 (SP2))

    You may be seeing the problem described in MSKB 820734: WD2002: Included File that Contains Merge Fields Does Not Suppress Blank Lines in Mail Merge. It was fixed in SP3 for Office XP. Also note that Word 2002 apparently insists that the second line be completely empty - one space character in the second address line, and the line is not suppressed.
    Wendell

  9. #9
    New Lounger
    Join Date
    Apr 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Word 2002 (SP2))

    I have had some annoyances when using the address block as well. When using Outlook contacts as my datasource I have had far greater success inserting these fields:

    Full Name
    Mailing Address

    (Throw Company Name in there as well if that's what you need)

  10. #10
    New Lounger
    Join Date
    Aug 2001
    Location
    Dallas, Texas, Texas, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Word 2002 (SP2))

    thanks for the tip on using the different field codes instead. I'll give that a try.

Posting Permissions

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