[FS]

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

[Doug Robbins - Word MVP]

{ 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

[FS]

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!