Printing to FAX

[Dougie Still Going Crazy]

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]

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>