|
I can do that much, and I may end up changing my data so that's all I have to do.
I'm using Windows XP and Word 2003 on my computer, Vista and Microsoft Office 2007 on my wife's. But I figure if I can get it coded right on one, it'll run on both.
My issue is the If ... Then ...Else command.
2007 has a "Rules" command that opens up an idiot-proof window for the If - Then - Else command. Unfortunately, I'm more of an idiot than they bargained for.
I want to set up a salutation line that will read either
Dear Mr. Smith,
or
Dear Mr. Smith and Ms. Jones,
So I type in Dear and then select the Title and LastName fields in the box. I select
If Last_Name_2 is not blank
then I go down to the box that asks you to insert text. I insert
and
After that, I try to insert the two new fields that I want
Title2 and Last_Name_2
but there's no way to insert fields, and if I just type in <<followed>> , etc., that doesn't work.
What do I do?
If I can make it work on either version, 2003 or 2007, it will work on the other.
Ultimately, I want to have three choices.
If there is no Last_Name_1 (it's a business, not an individual) I want the salutation to read
Dear Friends,
If there is a Last_Name_1 but no Last_Name_2, I want it to read
Dear Mr. Smith, (no "and," and no space before the comma)
If there is a Last_Name_2, I want it to read
Dear Mr. Smith and Ms. Jones
My inelegant brute force solution is to create three files, with the same letter, but different merge instructions on the salutation line -- 0, 1 or 2 names. Then make a column in Access that will have 0, 1 or 2, and do three different filters when I sent out the letter.
| 
