[Colonel Blip]

Hello, All!

My outlook 2k3 contact form is the default. The contact names take the form
of Full Name made up of First Name and Last name. First name for a husband
and wife is of the form "Jack & Jill". If they have a cell phone then the
Mobile field is his and the Other field is hers. I have created a mail merge
that works great (thanks to help from Graham here in the group. For the cell
phones in the merge I have an IF...Then...Else statement that checks that
each cell phone field is not blank and puts the text "Cell:" in front of the
number. What I would like to do is have it produce "Jack:" for the Mobile
number and "Jill:" in front of the Other field's number.

In some cases the Contact is single so it doesn't require any entry in front
of the number.

Is there a way to do this in a mail merge?

Thanks.

Thanks,
Colonel Blip.
E-mail:

[Graham Mayor]

No. You cannot read part of a field using an IF field.
The best you can manage with your data in this form is 'his' and 'hers'
eg
{IF {Mergefield Other_Phone} "" "His Cell {Mergefield Mobile_Phone}
Her Cell {Mergefield Other_Phone}" "Cell {Mergefield Mobile_Phone}"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Colonel Blip wrote:
Hello, All!

My outlook 2k3 contact form is the default. The contact names take
the form of Full Name made up of First Name and Last name. First name
for a husband and wife is of the form "Jack & Jill". If they have a
cell phone then the Mobile field is his and the Other field is hers.
I have created a mail merge that works great (thanks to help from
Graham here in the group. For the cell phones in the merge I have an
IF...Then...Else statement that checks that each cell phone field is
not blank and puts the text "Cell:" in front of the number. What I
would like to do is have it produce "Jack:" for the Mobile number and
"Jill:" in front of the Other field's number.
In some cases the Contact is single so it doesn't require any entry
in front of the number.

Is there a way to do this in a mail merge?

Thanks.

Thanks,
Colonel Blip.
E-mail:

[Colonel Blip]

Hello, Graham!
You wrote on Fri, 1 Sep 2006 09:06:25 +0300:

I suspected as much.

Thanks,

Colonel Blip.
E-mail:

GM No. You cannot read part of a field using an IF field.
GM The best you can manage with your data in this form is 'his' and 'hers'
GM eg
GM {IF {Mergefield Other_Phone} "" "His Cell {Mergefield Mobile_Phone}
GM Her Cell {Mergefield Other_Phone}" "Cell {Mergefield Mobile_Phone}"}

[Colonel Blip]

Hello, Graham!
You wrote on Fri, 1 Sep 2006 09:06:25 +0300:

On a related question, I googled all over the place but was never able to
find a good listing of all of the commands for coding (not macros/vba) and
examples of their use. Do you know of such a resource? Maybe I could figure
some of this stuff out rather than leeching all of the time with questions.

Thanks,

Colonel Blip.
E-mail:

GM No. You cannot read part of a field using an IF field.
GM The best you can manage with your data in this form is 'his' and 'hers'
GM eg
GM {IF {Mergefield Other_Phone} "" "His Cell {Mergefield Mobile_Phone}
GM Her Cell {Mergefield Other_Phone}" "Cell {Mergefield Mobile_Phone}"}

[Graham Mayor]

They are all listed and documented in vba help.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Colonel Blip wrote:
Hello, Graham!
You wrote on Fri, 1 Sep 2006 09:06:25 +0300:

On a related question, I googled all over the place but was never
able to find a good listing of all of the commands for coding (not
macros/vba) and examples of their use. Do you know of such a
resource? Maybe I could figure some of this stuff out rather than
leeching all of the time with questions.
Thanks,

Colonel Blip.
E-mail:

No. You cannot read part of a field using an IF field.
The best you can manage with your data in this form is 'his' and
'hers' eg
{IF {Mergefield Other_Phone} "" "His Cell {Mergefield
Mobile_Phone} Her Cell {Mergefield Other_Phone}" "Cell {Mergefield
Mobile_Phone}"}

[Colonel Blip]

Hello, Graham!
You wrote on Fri, 1 Sep 2006 09:06:25 +0300:

Another thought. Say I follow approach outlined in your message. What about
a macro that would read the First_Name, look for the "&" and if it found it
replace the "His" with the "Jack" name and if there was an Other replace the
"Her" with the "Jill" name? Is such code instruction possible with Word's
VBA?

Thanks again,

Colonel Blip.
E-mail:

GM No. You cannot read part of a field using an IF field.
GM The best you can manage with your data in this form is 'his' and 'hers'
GM eg
GM {IF {Mergefield Other_Phone} "" "His Cell {Mergefield Mobile_Phone}
GM Her Cell {Mergefield Other_Phone}" "Cell {Mergefield Mobile_Phone}"}

[Graham Mayor]

You couldn't do it as part of the mail merge - you would have to run the
code on the document created from the merge, but it should be possible. It
would however make more sense to use the Spouse field in Outlook and set up
your contacts so that they can be used as intended. You can access all of
the fields including custom fields from Outlook.
http://www.gmayor.com/mailmerge_from_outlook.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Colonel Blip wrote:
Hello, Graham!
You wrote on Fri, 1 Sep 2006 09:06:25 +0300:

Another thought. Say I follow approach outlined in your message. What
about a macro that would read the First_Name, look for the "&" and if
it found it replace the "His" with the "Jack" name and if there was
an Other replace the "Her" with the "Jill" name? Is such code
instruction possible with Word's VBA?

Thanks again,

Colonel Blip.
E-mail:

No. You cannot read part of a field using an IF field.
The best you can manage with your data in this form is 'his' and
'hers' eg
{IF {Mergefield Other_Phone} "" "His Cell {Mergefield
Mobile_Phone} Her Cell {Mergefield Other_Phone}" "Cell {Mergefield
Mobile_Phone}"}

[Colonel Blip]

Hello, Graham!
You wrote on Fri, 1 Sep 2006 17:08:36 +0300:

I thought about that about 5 iterations of questions ago g but decided,
for lack of knowing I couldn't do simply what I want to do, that it was too
much of a hassle. I would need to change my OL form and publish it, then go
thru and, I think, delete spouses from the first name and add them to the
Spouse field. I guess I could then test thru IF to see if the spouse was
populated and if it was do a "First_Name" " &" "Spouse_Name" "Last_Name"
construct in the IF statement, correct? Of course the cell phone number
assignments would be straight-forward.

Thanks,

Colonel Blip.
E-mail:

GM You couldn't do it as part of the mail merge - you would have to run
GM the code on the document created from the merge, but it should be
GM possible. It would however make more sense to use the Spouse field in
GM Outlook and set up your contacts so that they can be used as intended.
GM You can access all of the fields including custom fields from Outlook.
GM http://www.gmayor.com/mailmerge_from_outlook.htm

[Graham Mayor]

There are no easy solutions here - unless the Outlook guys know better
But if the data source is right you can construct the conditional fields as
you want them.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Colonel Blip wrote:
Hello, Graham!
You wrote on Fri, 1 Sep 2006 17:08:36 +0300:

I thought about that about 5 iterations of questions ago g but
decided, for lack of knowing I couldn't do simply what I want to do,
that it was too much of a hassle. I would need to change my OL form
and publish it, then go thru and, I think, delete spouses from the
first name and add them to the Spouse field. I guess I could then
test thru IF to see if the spouse was populated and if it was do a
"First_Name" " &" "Spouse_Name" "Last_Name" construct in the IF
statement, correct? Of course the cell phone number assignments would
be straight-forward.
Thanks,

Colonel Blip.
E-mail:

You couldn't do it as part of the mail merge - you would have to run
the code on the document created from the merge, but it should be
possible. It would however make more sense to use the Spouse field in
Outlook and set up your contacts so that they can be used as
intended. You can access all of the fields including custom fields
from Outlook. http://www.gmayor.com/mailmerge_from_outlook.htm

[Colonel Blip]

Hello, Graham!
You wrote on Fri, 1 Sep 2006 19:15:05 +0300:

Maybe there is a way of writing a macro that will at least take the
First_Name field and check for the & and if it finds it put the 2nd name in
the spouse field and delete the "& ..." part of the First_Name and export
all of it to the merge file data file. I should be so lucky. g

Thanks,

Colonel Blip.
E-mail:

GM There are no easy solutions here - unless the Outlook guys know better
GM But if the data source is right you can construct the conditional
GM fields as you want them.