[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!




--
Daedalusfbo

[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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Daedalusfbo" wrote in message news

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!




--
Daedalusfbo

[Daedalusfbo[_2_]]

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

Cheers!



macropod;2696628 Wrote:
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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Daedalusfbo" wrote in
message news
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!




--
Daedalusfbo -




--
Daedalusfbo