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 / April 2008

Tip: Looking for answers? Try searching our database.

Sometimes print an envelope & sometimes not

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
magicdds- - 26 Apr 2008 23:25 GMT
I have a mailmerge envelope and letter that is opened from Access. There is a
yes/no field in the merge query, named ENVELOPE.

Is there a way to set up an "IF" field in the envelope part of the document
such that IF ENVELOPE = "true" then the envelope prints, followed by the
letter
If ENVELOPE = "False" then only the letter prints

Or perhaps someone has a suggestion of a better way for the user in Access
to indicate if, when the merge is made to Word, Word should display both the
envelope and letter or just the letter.

Thanks for any ideas.
Mark
Graham Mayor - 27 Apr 2008 08:39 GMT
Mixed merges are difficult enough at the best of times. You would be better
creating a separate envelope merge with a SkipIf field at the start eg

{ SKIPIF { MERGEFIELD Envelope \*Upper } = "FALSE"  }

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a mailmerge envelope and letter that is opened from Access.
> There is a yes/no field in the merge query, named ENVELOPE.
[quoted text clipped - 10 lines]
> Thanks for any ideas.
> Mark
 
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.