Is it possible to send a fax from Access?

[dunnjt]

Can a fax be sent from Access without going through Word? I want to fax a permit application but when I send my report (The permit application) to Word to fax it, the document is displayed in a table showing all records instead of just the one record for the current permit application.
Can someone recommend a way to fax a simple form, with data either directly from Access or by going through Word. I don't write code but am very familiar with Access. Can anyone help?
Thank You,
Jerry D.

 

[koresnordic]

How do you fax from word? Is it via a printer driver style of interface? If so, can you not send the print from an access report (your fax) straight to this driver?



Graham

 

[dunnjt]

Koresnordic-
Thanks for your reply. How can I send an Access report to Fax? The report would always be just one simple page but I am not sure how to send it or where to send it to fax. when I fax in Word, I open the Fax software, compose the message and attach the report in Word. Works fine. How do I "select" an Access report to attach to the fax as I do with a Word document.
Thanks for any suggestions.
Jerry D.

 

[koresnordic]

Call me Graham please,
What software fax are you using, are you using winfax for example? A lot of fax software sets up a virtual printer that you can send documents to. You print to this instead of a normal printer. It then prompts you for the fax number to send it to. If this isn't installed with your fax software, have a look at the documentation to see if it is possible. If not then you will have to export to an rtf file (when the report is open). The problem is you will lose a lot of formatting (boxes, shading etc).



Graham

 

[bitmite]

if you are using windows XP there is a fax driver that you can install

once you have done this you can then use the print command but instead of selecting a printer select the fax. A wizard will then walk you throught the rest

 

[BlaineR]

Hi,

If you just want to stick with whatever you are comfortable with in Word, and you just want to be able to do a merge from the record you are currently in rather than all of the records, you can do that, too.

What you want to do is to create a query that returns just the current record from the form, and then use that query (rather than the entire Table) as the data source in the mail merge.

To create the query, bring the entire Table into the query with all fields showing...that gives you all the fields for all the records in the Table. Then, just bring in the field that is your unique record identifier. For that field, specify the criteria as:

=[Forms]![yourFormName]![yourUniqueRecordIdField]

(You can click off the Display or Show box (whatever it is) because you've already included it when you brought in all fields from the Table.)

This will narrow down the records to one, since it returns just the record currently populating the form (or the first record if the form isn't open).

Then, you can go and create (or update) your mail merge using the query you just created as the data source, rather than the Table itself.

When I learned to do this, I was helped by FAQ 181-271.

- Blaine