Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
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: |
#2
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Another mailmerge question
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: |
#3
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Another mailmerge question
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}"} |
#4
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Another mailmerge question
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}"} |
#5
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Another mailmerge question
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}"} |
#6
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Another mailmerge question
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}"} |
#7
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Another mailmerge question
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}"} |
#8
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Another mailmerge question
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 |
#9
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Another mailmerge question
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 |
#10
Posted to microsoft.public.outlook.general,microsoft.public.word.newusers
|
|||
|
|||
Another mailmerge question
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indicate a mailmerge record number before launching Word? | Mailmerge | |||
Mailmerge and Access | Mailmerge | |||
Hi...Two Question Concerning Envelopes via MailMerge... | Mailmerge | |||
Protect mailmerge document | Mailmerge | |||
Included Property in Word 2003 MailMerge | Mailmerge |