Another mailmerge question

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: colonelblip.no.spam.please@bigfoot.com

Graham
Fri Sep 01 01:06:25 CDT 2006

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: colonelblip.no.spam.please@bigfoot.com

Colonel
Fri Sep 01 05:07:36 CDT 2006

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

I suspected as much.

Thanks,

Colonel Blip.
E-mail: colonelblip.no.spam.please@bigfoot.com

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
Fri Sep 01 05:15:45 CDT 2006

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: colonelblip.no.spam.please@bigfoot.com

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
Fri Sep 01 06:37:14 CDT 2006

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: colonelblip.no.spam.please@bigfoot.com
>
>> 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
Fri Sep 01 08:50:36 CDT 2006

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: colonelblip.no.spam.please@bigfoot.com

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
Fri Sep 01 09:08:36 CDT 2006

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: colonelblip.no.spam.please@bigfoot.com
>
>> 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
Fri Sep 01 09:24:45 CDT 2006

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: colonelblip.no.spam.please@bigfoot.com

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
Fri Sep 01 11:15:05 CDT 2006

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: colonelblip.no.spam.please@bigfoot.com
>
>> 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
Fri Sep 01 11:48:50 CDT 2006

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: colonelblip.no.spam.please@bigfoot.com

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.