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 / December 2005

Tip: Looking for answers? Try searching our database.

Making address lines stay even though they're blank

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nick Pedder - 09 Dec 2005 15:51 GMT
Hi,

Right, I'm being stupid here, because I know this is possible and I've done
it many times before! Unfortunately I've obtained a mental block and have
been trying to work this out for the last couple of hours with no joy!

I've got an excel spreadsheet with basic information which I'm trying to
merge into a form letter. However, if I'm only filling 4 out of the 5 lines
for the address, the whole lot of letters is being shifted out of synch and
they have to manually be sorted out. How do I select the mail field so it
will not alter the format of the document, regardless of whether it contains
information?

A point in the right direction would be greatly appreciated!

Thanks,

Nick
Doug Robbins - Word MVP - 09 Dec 2005 19:28 GMT
One sure way would be to put the individual mergefields into separate cells
in a single column table.

Alternatively, you could use an If...then...else field that inserted a new
line if the field is blank and inserted the mergefield if it wasn't.

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

> Hi,
>
[quoted text clipped - 18 lines]
>
> Nick
 
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.