Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
address format in mailmerge
I am trying to mail merge to a word template from access. Below is
the fields that I am using «Title» «FrstName» «FamName» «Add1» «Add2» «Add3» «Add4» «Post» Simple enough But the problem is that not all entries into the database have an address field 3 or an address 4 but the post code must attach to the end of the last address field. so address should actually look more like «Title» «FrstName» «FamName» «Add1» «Add2» «Post» OR «Title» «FrstName» «FamName» «Add1» «Add2» «Add3» «Post» How do I ensure that the post field attaches to the end of the last address field? Have tried IF statements. Any help appreciated. Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
address format in mailmerge
{ IF { MAILMERGE Add4 } "" "{ MAILMERGE Add2 }[Enter]
{ MAILMERGE Add3 }[Enter] { MAILMERGE Add4 } { MAILMERGE Post }" "{ IF { MAILMERGE Add3 } "" ""{ MAILMERGE Add2 }[Enter] { MAILMERGE Add3 } { MAILMERGE Post }" "{ MAILMERGE Add2 } { MAILMERGE Post }" } } You use Enter or start a new line where (and in place of the [Enter]s in the above. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "FS" wrote in message ... I am trying to mail merge to a word template from access. Below is the fields that I am using «Title» «FrstName» «FamName» «Add1» «Add2» «Add3» «Add4» «Post» Simple enough But the problem is that not all entries into the database have an address field 3 or an address 4 but the post code must attach to the end of the last address field. so address should actually look more like «Title» «FrstName» «FamName» «Add1» «Add2» «Post» OR «Title» «FrstName» «FamName» «Add1» «Add2» «Add3» «Post» How do I ensure that the post field attaches to the end of the last address field? Have tried IF statements. Any help appreciated. Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
address format in mailmerge
On Jul 23, 3:14*pm, "Doug Robbins - Word MVP"
wrote: { IF { MAILMERGE Add4 } "" "{ MAILMERGE Add2 }[Enter] { MAILMERGE Add3 }[Enter] { MAILMERGE Add4 } { MAILMERGE Post }" "{ IF { MAILMERGE Add3 } "" ""{ MAILMERGE Add2 }[Enter] { MAILMERGE Add3 } { MAILMERGE Post }" "{ MAILMERGE Add2 } { MAILMERGE Post }" } } You use Enter or start a new line where (and in place of the [Enter]s in the above. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "FS" wrote in message ... I am trying to mail merge to a word template from access. *Below is the fields that I am using «Title» «FrstName» «FamName» «Add1» «Add2» «Add3» «Add4» «Post» Simple enough But the problem is that not all entries into the database have an address field 3 or an address 4 but the post code must attach to the end of the last address field. so address should actually look more like «Title» «FrstName» «FamName» «Add1» «Add2» «Post» OR «Title» «FrstName» «FamName» «Add1» «Add2» «Add3» «Post» How do I ensure that the post field attaches to the end of the last address field? *Have tried IF statements. *Any help appreciated. Thanks Excellent thanks very much for this! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge is not adding a title after name for address labels. | Mailmerge | |||
Creating address labels with mailmerge | Mailmerge | |||
how to convert single address line into a letter address format? | Page Layout | |||
Specifying a sending address in mailmerge | Mailmerge | |||
mailmerge using .txt address files | Mailmerge |