C
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: (e-mail address removed)
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: (e-mail address removed)