Unknown name in mail merge

[Daedalusfbo]

Hi everyone! I need to send out about 500 form letters to different
companies. I have my database and form letter all set up as follows:

«Title» «First_Name» «Last_Name»
«Company_Name»
«Address_Line_1»
«City» «State»
«ZIP_Code»

Dear «Title» «Last_Name»:


The problem is that I don't have a last name for all of the companies
in my database. Therefore, when I go to print my form letter, the
greeting will look like this: "Dear:" because the last name in the
database is left blank.

I can't enter Sir or Madam under the last name in the Database because
then my form letter will look like this:

Sir or Madam
Company ABC
123 Street
City, State
Zip Code

Dear Sir or Madam:


Can someone please tell me how I can get my form letter to
automatically enter "Sir or Madam" under the greeting when I don't have
a last name in my database (without having it show up under the top line
of my address line)?

Thank you!

 

[macropod]

Hi Daedalusfbo,

Here's how:
.. Copy your «Last_Name» field and paste it into your document ahead of the «Title» field
.. Select all three fields and press Ctrl-F9 to enclose them in a new field, thus:
{«Last_Name»«Title» «Last_Name»}
.. Fill in around the new field braces thus, paying careful attention to the spacing:
{IF«Last_Name»= "" "Sir or Madam" "«Title» «Last_Name»"}
.. Position the cursor anywhere in this field and press F9 to update it
.. Run your mailmerge

Cheers

 

[Daedalusfbo]

omg! Thank you very much, macropod! Wow, you've saved me a lot of tim
and unnecessary printing.

Cheers!

Hi Daedalusfbo,

Here's how:
.. Copy your «Last_Name» field and paste it into your document ahead o
the «Title» field
.. Select all three fields and press Ctrl-F9 to enclose them in a ne
field, thus:
{«Last_Name»«Title» «Last_Name»}
.. Fill in around the new field braces thus, paying careful attentio
to the spacing:
{IF«Last_Name»= "" "Sir or Madam" "«Title» «Last_Name»"}
.. Position the cursor anywhere in this field and press F9 to updat
it
.. Run your mailmerge

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Daedalusfbo" (e-mail address removed) wrote i
message
Hi everyone! I need to send out about 500 form letters to different
companies. I have my database and form letter all set up as follows:

«Title» «First_Name» «Last_Name»
«Company_Name»
«Address_Line_1»
«City» «State»
«ZIP_Code»

Dear «Title» «Last_Name»:


The problem is that I don't have a last name for all of the companies
in my database. Therefore, when I go to print my form letter, the
greeting will look like this: "Dear:" because the last name in the
database is left blank.

I can't enter Sir or Madam under the last name in the Databas
because
then my form letter will look like this:

Sir or Madam
Company ABC
123 Street
City, State
Zip Code

Dear Sir or Madam:


Can someone please tell me how I can get my form letter to
automatically enter "Sir or Madam" under the greeting when I don'
have
a last name in my database (without having it show up under the to
line
of my address line)?

Thank you!