A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Insert comma into address block



 
 
Thread Tools Display Modes
  #1  
Old September 3rd, 2004, 08:51 PM
J K Bliss
external usenet poster
 
Posts: n/a
Default 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  
Old September 3rd, 2004, 11:51 PM
Paul Lautman
external usenet poster
 
Posts: n/a
Default

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  
Old September 4th, 2004, 09:05 AM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.