mail merge address formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

katet - 10 Aug 2005 14:10 GMT

I am doing a mail merge with a letter in word and the address details from an
excel spreadsheeet. It is all faily simple, but I want to format the address
layout more than it will allow.

It seems to only allow 5 lines for any address meaning that the last line
often contains lots of information seperated by commas
eg. Slough, Berks, XXX XXX
Whereas I want to format it so that they are on their own lines eg.
Slough
Berks
XXX XXX

Can I do this as part of the merge, or do I have to go through the final
document at the end and do it manually??

Reply to this Message

Doug Robbins - 10 Aug 2005 14:32 GMT

Rather than using the Address Block field, just insert the individual
mergefields in the arrangement that you want.

Signature

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

>I am doing a mail merge with a letter in word and the address details from
>an
[quoted text clipped - 12 lines]
> Can I do this as part of the merge, or do I have to go through the final
> document at the end and do it manually??

Reply to this Message

Cindy Meister - 10 Aug 2005 14:37 GMT

Which version of Word are we discussing?

Normally, Word doesn't limit the number of lines for anything, unless you're
working in a frame or a table cell with a set height...

Are you trying to use the AddressBlock for the addresses? How about if you
simply insert the individual merge fields in the layout you'd like to have?

-- Cindy

> I am doing a mail merge with a letter in word and the address details from an
> excel spreadsheeet. It is all faily simple, but I want to format the address
[quoted text clipped - 10 lines]
> Can I do this as part of the merge, or do I have to go through the final
> document at the end and do it manually??

Reply to this Message

katet - 10 Aug 2005 15:04 GMT

Thanks - I didn't realise that's what the "more items" function allowed.

Just done a quick test and it seems to do what I need - but do I have to
worry about commas etc. For instance if I want to stipulate that the 3rd and
4th lines of the address follow each other sepearted by a comma, can i just
leave it as
<<Address_1>><<Address_2>>
and know that it will do it automatically or do I have to manually insert a
comma and a space eg:
<<Address_1>>, <<Address_2>>

> Which version of Word are we discussing?
>
[quoted text clipped - 20 lines]
> > Can I do this as part of the merge, or do I have to go through the final
> > document at the end and do it manually??

Reply to this Message

Cindy Meister - 10 Aug 2005 17:03 GMT

You have to manually insert the comma and the space.

And, if some things are conditional, you have to manually build an IF field
to handle it.

-- Cindy

> Thanks - I didn't realise that's what the "more items" function allowed.
>
[quoted text clipped - 31 lines]
> > > Can I do this as part of the merge, or do I have to go through the final
> > > document at the end and do it manually??

Reply to this Message