If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Insert comma into address block
The standard MS address block in the mail merge does not
put a comma after the last name and before the suffix if the person has a suffix (Jr. etc) Does anyone know how to edit the address block to include a comma after the last name if there is a suffix? I have toggled on the fields of the address block and have tried hard coding a comma and it does not show up in the preview. I also tried to use an If..Then..Else but it did not show up in the preview. I know I'm missing something but I cannot figure it out. Thanks for your help. |
#2
|
|||
|
|||
1) Select the suffix field
2) Press Alt-F9 to show the field codes 3) Assuming that the field is called suffix, edit the field so that it says: { MERGEFIELD "suf" \b ,} 4) Alt-F9 again Job done "J K Bliss" wrote in message ... The standard MS address block in the mail merge does not put a comma after the last name and before the suffix if the person has a suffix (Jr. etc) Does anyone know how to edit the address block to include a comma after the last name if there is a suffix? I have toggled on the fields of the address block and have tried hard coding a comma and it does not show up in the preview. I also tried to use an If..Then..Else but it did not show up in the preview. I know I'm missing something but I cannot figure it out. Thanks for your help. |
#3
|
|||
|
|||
I don't think you will be able to do this in ADDRESSBLOCK
a. if you display the text of the ADDRESSBLOCK using Alt-F9 and put text inside the , in most cases it will display only if that field is non-blank. However, Word seems to treat the first line of fields in the ADDRESSBLOCK in a completely different way so that this approach does not work b. manual edits to ADDRESSBLOCK arte very easily lost and are not recommended by MS So you'll probably need to use individual MERGEFIELDs as suggested by Paul Lautman -- Peter Jamieson "J K Bliss" wrote in message ... The standard MS address block in the mail merge does not put a comma after the last name and before the suffix if the person has a suffix (Jr. etc) Does anyone know how to edit the address block to include a comma after the last name if there is a suffix? I have toggled on the fields of the address block and have tried hard coding a comma and it does not show up in the preview. I also tried to use an If..Then..Else but it did not show up in the preview. I know I'm missing something but I cannot figure it out. Thanks for your help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Express Address Book within Outlook | J. Lehman | Contacts | 8 | July 16th, 2004 10:35 PM |
Comma seperated email address of group members | Venkat | Contacts | 2 | July 9th, 2004 12:45 AM |
Outlook 2003 e-mail problem | Mauro | Contacts | 5 | June 24th, 2004 09:19 PM |
Word - inserting an address | Bill Stevenson | General Discussions | 2 | May 12th, 2004 09:49 PM |
Address block | Renate | Setting up and Configuration | 2 | February 9th, 2004 01:06 PM |