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 / Programming / December 2007

Tip: Looking for answers? Try searching our database.

Printing to FAX

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dougie Still Going Crazy - 28 Dec 2007 06:07 GMT
I have a WORD document that, when it opens, offers a list from a query in
ACCESS.  The user then chooses the record/s he wants and then the information
is Merged to the document.  I have to unprotect and then protect the document
with code as it won't merge with the protection on and there are text form
fields for the user to fill in (which I may change to input boxes).

I have a couple of questions:
1. How do I stop it from merging to a new document as the form text fields
don't then appear in the new document.  I want it to merge to the original
doc.  I can get the new document to close but I want it to do so without
asking if I want to save it first.  Much better if it just merges to the
original document.

2.  I can get it to printout to the FAXmaker but what code do I need so that
I can set the "To" field to a group from my Outlook Contacts and I also want
to set the subject field.  (Where do I find a list of the names of these
boxes?)  Our FAXmaker comes up with a form similar to sending an email.  I
then want it to automatically send.

Hope you Boffins can help this amatur.

Cheers
Graham Mayor - 28 Dec 2007 09:31 GMT
It is not going to work. Mail merge and protected forms are mutually
exclusive. Nor can you merge simultaneously from two data sources i.e.
Access and Outlook. Whether or not your fax software can be programmed with
vba is something that you will have to take up with the writers of that
software. You *may* be able to merge to fax with Word 2003 using Windows Fax
software, but I have no idea about Faxmaker.

My feeling is that you will have to develop (or get someone to develop for
you) a custom application using Userforms to collect the data from Access
and/or Outlook and insert it in the document. You could make a start at Word
MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm and you will find some more
sophisticated uses of Userforms on fellow MVP Greg Maxey's web site
http://gregmaxey.mvps.org/word_tips.htm

Signature

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

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

> I have a WORD document that, when it opens, offers a list from a
> query in ACCESS.  The user then chooses the record/s he wants and
[quoted text clipped - 19 lines]
>
> Cheers

Rate this thread:






 
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.