Reply
 
Thread Tools Display Modes
  #1   Report Post  
katet
 
Posts: n/a
Default mail merge address formatting

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??


  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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

--
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
"katet" wrote in message
...
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??




  #3   Report Post  
Cindy Meister
 
Posts: n/a
Default

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

"katet" wrote:

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??


  #4   Report Post  
katet
 
Posts: n/a
Default

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_1Address_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


"Cindy Meister" wrote:

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

"katet" wrote:

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??


  #5   Report Post  
Cindy Meister
 
Posts: n/a
Default

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

"katet" wrote:

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_1Address_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


"Cindy Meister" wrote:

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

"katet" wrote:

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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
how do I setup a mail merge with 4 separate address blocks (postca misschipper Mailmerge 1 March 10th 05 07:34 PM
How to remove unwanted formatting in mail merge for cells witn no Jim Mailmerge 3 March 4th 05 09:13 AM
How do I create an address book used for mail merge in Word XP RDOC Mailmerge 0 February 10th 05 05:59 PM
mail merge to a secondary email address Paul Dustin Mailmerge 1 December 1st 04 05:41 PM


All times are GMT +1. The time now is 04:55 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"