Fax or Email MS Access Report

[kay]

Que: I have a report which has these fields - StudentID(unique), StudentName
, StudentPhoneNumber, StdfaxNumber,StdEmailid, MissingDocuments

Now instead of faxing/emailing manually I would like to automate this
process in ms access database.
I have this report created in MS ACCESS and I want to automate this process
so that when I click on send faxes or send email button, it should send fax
or email to each student saying you are missing these documents.

Is there a way in MS ACCESS to do this? I have created some simple macros
but do not know how to do this. ( I tried using send objects but that wont
work here as each student should receive information about his missing
documents)

Thanks for the help

 

[Arvin Meyer [MVP]]

I use code developed by now ex-MVP Steve Arbaugh:

http://www.groupacg.com/

It handles creating PDF's and setting up emailing them to individuals.
Faxing is more difficult. Steve's email and PDF class will build the proper
files for you, but you need a sophisticated fax card and program top fax
them. The one I set up for a client, cost over $9,000, and was the cheapest
solution. There were 2 other fax programs, but one cost way more, and the
other wouldn't work with Access.

The fax card I used was a Brooktrout 1034 for a T1 line, but they have
cheaper ones, and the fax program I used was GFI's Faxmaker. There was a lot
of programming involved and many obstacles to overcome. Another client
looked at the cost and just made a requirement that all his suppliers use
email, or find another customer.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

You can thank the FTC of the USA for making this disclaimer necessary.

 

[Mark Andrews]

Emailing a pdf is quite common. Basically run through a recordset and send
the email with pdf attachment. In Access2003 or earlier look at Stephen
Lebans pdf routines to create the pdf file, or use a pdf printer driver you
can control through the registry.

We have some nice batch reporting features in this product:
http://www.rptsoftware.com/products/email/
You can see some example code of emailing out pdf files to multiple people
on the website.

For faxing, that's a little less common, try these links or perhaps look at
something like eFax to see if you can automate the fax going through that
service.
http://support.microsoft.com/kb/231797

http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4GGLL_en&q=fax+a+access+report

I think the advice of just using email might be a good decision.

HTH,
Mark
RPT Software
http://www.rptsoftware.com

 

[Tony Toews [MVP]]

Is there a way in MS ACCESS to do this? I have created some simple macros
but do not know how to do this. ( I tried using send objects but that wont
work here as each student should receive information about his missing
documents)

You'll need to work with VBA. Unless you have a beta copy of Access
2010.

You need to loop through each record in the query and then produce the
individual reports.

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required. Free.
http://www.lebans.com/reporttopdf.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/