 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2004Adjust/align up
I'm merging letters -- Word 2002 with MS Access 2002. The addresses in the database have from three to six lines. Is there a way to adjust the lines "up" so the last line of a letter is always in the same place regardless of the number of lines in the address? Thank you so much! A single table cell without a border; alignment set to bottom will work.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I'm merging letters -- Word 2002 with MS Access 2002. > The addresses in the database have from three to six [quoted text clipped - 5 lines] > > Thank you so much! Thank you for your response but does this apply to a mail merge? I have tried your solution, but when the letters merge the number of address lines still push the bottom line up or down accordingly. >-----Original Message----- >A single table cell without a border; alignment set to bottom will work. [quoted text clipped - 10 lines] > >. In that case there is a field in the address that is sometimes unfilled and the merge is leaving space for it. You could insert the address using conditional statements that only produce the line feed and field when the field has content eg {Mergefield FirstName} {Mergefield LastName}{IF {Mergefield Company} <> "" " {Mergefield Company}"}{IF {Mergefield Address1} <> "" " {Mergefield Address1}"} etc Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thank you for your response but does this apply to a mail > merge? I have tried your solution, but when the letters [quoted text clipped - 24 lines] >> >> . |
Reply to this Message |
 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.