MERGE ACCESS REPORT TO FAX

[Guest]

I have a 20-page Access 2003 report. Each page needs to go to a different
fax number. How can I automate the faxing? Can I do a mail merge right
from Access? I have tried sending the report to Word (rtf) to do the fax
merge there, but I loose all the formatting on my report (letterhead, lines,
boxes). If it can't be done (and I suspect it can't, based on seanning other
newsgroup queries), can you forward this to the developers for a future
enhancement? Thanks!

 

[Steve Schapel]

Sammy,

Yes this is possible, but Access doesn't have native fax transmission
functionality. So your solution will depend on how you send your faxes.
Some people use WinFax Pro. Tony Toews has some relevant information
at http://www.granite.ab.ca/accswfxp.htm
and Steve Arbagh has a WinFax integration library, which I have
successfully used myself, available at
http://ourworld.compuserve.com/homepages/attac-cg/