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 2004

Tip: Looking for answers? Try searching our database.

Mail Merge From MS Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dunner - 16 Aug 2004 10:46 GMT
Hi,

I am trying to create a mail merge from an MS Access
database with the address details and some additional
fields. These additional fields are Yes/No input fields
that indicate if something is outstanding or not.

What I would like to do is create a mail merge field that
checks this yes/no value and if it is yes places the name
of the item in the field and if it is no leaves it blank.

Is this even possible or would I be better off trying to
create the letter as a form/report in the database?

Thanks for your help

Dunner
Doug Robbins - 16 Aug 2004 23:59 GMT
It is possible using and If...then...Else field in the mailmerge main
document, but in my view, databases are better at data manipulation so you
might be better off creating a query in Access in which you use the IIF()
function and then use that query as the datasource.

Depending upon what you are doing, it might also be better to do the whole
thing in Access with a Report.
Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

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