Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Tanya Tanya is offline
external usenet poster
 
Posts: 23
Default merge fields alignment

I am having trouble aligning merged fields in the address block of main
document

"Trading Name" "Organisation Name" on the one line in the address block:

If the data record (from excel) does not have "Trading Name" info and is
blank - the row will not align/shift/move the "Organisation Name" to the
left margin. I have tried switches advance\l6 etc but just have overlap.. I
must be missing the basic.!

Any help appreciated (please be very basic in any instructions)

Tanya
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default merge fields alignment

I am not sure whether your reference to address block is to the AddressBlock
field or to an area of the document. If it is to the AddressBlock field,
don't use it. Rather insert the mergefields that you want in the
configuration that you want them.

If the TradingName field is blank, you will need to use an
If...then...Else... field construction to avoid the unwanted space

{ IF { MERGEFIELD "TradingName" } "" "{ MERGEFIELD "TradingName" } {
MERGEFIELD "OrganizationName" }" "{ MERGEFIELD "OrganizationName" } }

You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to toggle of their display.

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

"Tanya" wrote in message
news
I am having trouble aligning merged fields in the address block of main
document

"Trading Name" "Organisation Name" on the one line in the address block:

If the data record (from excel) does not have "Trading Name" info and is
blank - the row will not align/shift/move the "Organisation Name" to the
left margin. I have tried switches advance\l6 etc but just have overlap..
I
must be missing the basic.!

Any help appreciated (please be very basic in any instructions)

Tanya



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Tanya Tanya is offline
external usenet poster
 
Posts: 23
Default merge fields alignment

Thanks for the quick response! I have tried as suggested, however it is
still not lining up on the left margin of the letter if the first field does
not have information. It still leaves one space (and am not using the
address block)

Any other suggestions??

"Doug Robbins - Word MVP" wrote:

I am not sure whether your reference to address block is to the AddressBlock
field or to an area of the document. If it is to the AddressBlock field,
don't use it. Rather insert the mergefields that you want in the
configuration that you want them.

If the TradingName field is blank, you will need to use an
If...then...Else... field construction to avoid the unwanted space

{ IF { MERGEFIELD "TradingName" } "" "{ MERGEFIELD "TradingName" } {
MERGEFIELD "OrganizationName" }" "{ MERGEFIELD "OrganizationName" } }

You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to toggle of their display.

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

"Tanya" wrote in message
news
I am having trouble aligning merged fields in the address block of main
document

"Trading Name" "Organisation Name" on the one line in the address block:

If the data record (from excel) does not have "Trading Name" info and is
blank - the row will not align/shift/move the "Organisation Name" to the
left margin. I have tried switches advance\l6 etc but just have overlap..
I
must be missing the basic.!

Any help appreciated (please be very basic in any instructions)

Tanya




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
A Merge letter requiring one or more different different mege letters depending on entry in fields rjr Microsoft Word Help 1 May 21st 06 05:16 PM
Mail merge and blank fields Lely Mailmerge 2 February 10th 06 02:24 PM
mail merge and text form fields Miss Su Mailmerge 1 February 4th 06 09:29 PM
Inserting Merge Fields CyberTaz Microsoft Word Help 3 January 28th 06 06:41 AM
truncated merge fields tferro Mailmerge 1 November 2nd 05 05:36 AM


All times are GMT +1. The time now is 12:40 PM.

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

About Us

"It's about Microsoft Word"