Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2006

Tip: Looking for answers? Try searching our database.

merge fields alignment

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tanya - 02 Aug 2006 00:55 GMT
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
Doug Robbins - Word MVP - 02 Aug 2006 04:46 GMT
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.

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 having trouble aligning merged fields in the address block of main
> document
[quoted text clipped - 10 lines]
>
> Tanya
Tanya - 02 Aug 2006 05:42 GMT
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??

> 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,
[quoted text clipped - 24 lines]
> >
> > Tanya
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.