Automated Faxes Using MS Access VBA

[hoialmen]

Hello All!

I'm looking for VBA guru who has experience automating faxes from MS Access. Here's what I'm trying to do:

I have an Access 2000 database application that contains contact information for our company. I want to build a VBA procedure in this app that will:

1) Pull a selected list of contacts and their fax numbers from the database.

2) Insert the contact information for each contact into the appropriate fields in a MS Word fax cover page.

3) Insert a PDF file as an attachment.

4) Send the fax.

5) Loop to next contact and repeat.

Now, I have seen a couple of posts that cover how to use the SendObject function to fax an Access db object (i.e. reports, tables, queries, etc.), however, in my case I am not sending an Access db object but rather a Word fax cover with a PDF attachment. I'm sure there must be a way to pull this off, I'm just not exactly sure how.

Additional Information:
I have installed WinFax Pro v10
I am running Outlook 2000
I am connected to an analog phone line

Any advice or code samples that can be offered to assist me will be greatly appreciated!

Thanks in advance,

Nate

 

[JimInKS]

Try looking at this link:

http://www.symantec.com/techsupp/files/winfax/winfaxsdk-9598nt.html

I have used the information from Larry Gordon with good success in Access 97. It is not a trivial exercise to make this work however, so good luck.