Results 1 to 13 of 13
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge (2002)

    Hello everyone:

    I am trying to do a mail merge, and I am having problems with the Dear Mr. Smith. I don't see the Dear Mr. Smith showing.

    Thanks

    dillon

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Mail Merge (2002)

    How you do this depends on your data source and your main document. If your data source has a "title" field (e.g., Mr., Ms., Dr.) and a last name/surname field, you can insert mergefields for both of those into your main document where you want your salutation to appear. This may appear to duplicate fields that are in your address block, but Word doesn't mind: you can repeat them as often as you like.

  3. #3
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (2002)

    Hello jscher2000:

    thank for your support, I understand what you mean, one of the problems that I had was that some of the addresses are male, and some female, there is nothing that allows you to automactically change Mr. to Mrs.

    this needs to be done manually; I found it easier to use the "insert merge fields" button.

    Again, thanks for your support

    dillon

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

    Re: Mail Merge (2002)

    If you have a field in the data source that indicates gender, you can use an IF field to insert Mr. or Mrs. as appropriate. Click the Insert Word Field button on the Mail Merge toolbar, If ... Then ... Else ... will be one of the available options.

  5. #5
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (2002)

    Hello HansV:

    I am using word 2002, so I will have to check, I found the "insert word field" I noticed that it has the "if..then..else option, I will play with and see what I can do.

    With the initial data source that I created, I did not use Mr. or Mrs; so I might have to go back and edit my data source.

    Thank you,

    dillon

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

    Re: Mail Merge (2002)

    How do you see whether a record is for a male or a female person? If only by the first name (Dick or Jane), it'll have to be manual.

  7. #7
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Mail Merge (2002)

    Hi dillon,

    If your database has a sex field (M/F), then you could use and IF test coded like:
    {IF{MERGEFIELD Sex}= M Mr Ms}
    Note that I used the ambiguous Ms for the female result - unless you've got something to indicate marital status, or at least Miss/Ms/Mrs preference, Ms seems the safest result to use. Mind you, addressing professional people with Mr/Ms instead of Dr, Prof, etc is a minefield too.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Spokane, Washington, USA
    Posts
    332
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (2002)

    > Mind you, addressing professional people with Mr/Ms instead of Dr, Prof, etc is a minefield too.

    I usually add an "honorific" field to my databases when there's any possibility I'll use it for a letter. That way, when filling in the new record information I have the choice of whether to use Mr/Ms/Dr., etc.
    Samantha

    Everything in excess! To enjoy the flavor of life, take big bites. Moderation is for monks!
    Robert A. Heinlein - Time Enough for Love

  9. #9
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (2002)

    Hello Everyone:

    Thanks Macropod: for the insert merge code, just to confirm with you; I have my main document and I used the "Insert Word Field" to be able to setup the addresses, instead of the "Insert Address Block"

    With the Salutation (Dear Mr. So and so) I just typed the word Dear and then I went back and used the "Insert word Field" again for the "Last Name" merge field.

    How would I use your merge field that you have provided for me?

    Thanks for your input Hans, Samantha, much appreciated. At the moment I am crunched for time, so I did exactly what Hans suggested, I did it manually.

    dillon

  10. #10
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Mail Merge (2002)

    Hi Dillon,

    Perhaps the easiest way is to use the coding I suggested is to press Ctrl-F9 twice, to create a pair of nested fields, thus '{ { } }' and type the text from my previous post within them so that you end up with:
    {IF{MERGEFIELD Sex}= M Mr Ms}
    Change 'Sex' to whatever field identifier your source data have.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  11. #11
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (2002)

    Hello Macropod:

    I went back into my main document, and review the recipient list, I went into customize, and realise that I would be able to add Mr or Mrs or Ms

    I will go into the main document and use your code, I just wanted to confirm that your code would go on the salutation line, I am sure that it does. Please see the following attachment,

    dillon
    Attached Files Attached Files

  12. #12
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Mail Merge (2002)

    <P ID="edit" class=small>(Edited by macropod on 03-Jun-06 08:16. A couple of words were missed out when first posted.)</P>Hi Dillon,

    Yes, that's where it would go - before the First_Name field on the address line too, if you want. Note that, after you've done the coding, it won't show up the same way as the other mergefields - it'll simply default to 'Ms'.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  13. #13
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (2002)

    Hello Macropod:

    I personally do not use Mr. or Ms. Mrs. on the addresse block any longer, however, I do use it on the Salutation line of course, including the labels also.

    I am doing a large mailout for a client and he was in a rush, since I have completed the merge manually, I will test this out over the weekend. I took a look at "Osbourne complete reference" and the instructions are very minimal.

    Thank you for your support Macropod, I will test your code tomorrow, so please stay tuned. Yesterday, I used the receipient list to do my labels and everything worked out fine. Now I am just going to print the merge.

    dillon

Posting Permissions

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