Can I Send a Fax from a Macro inAccess?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a Macro in Access to send different Reports/Tables to
different fax numbers. e.g. 1 report to 1 location - Is there any way / easy
way to do this?

Thanks!
 
Worldrallyteam,

In my experience, you would need to use faxing software such as WinFax
Pro which supports programmatic control. Steve Arbagh has a utility for
this available at http://ourworld.compuserve.com/homepages/attac-cg/

However, I have also seen someone recently say that you can use Outlook
Automation, and just replace the 'To' field with a fax number in the
syntax like...
[Fax: 1234546]
I have not checked this, but may be worth a try. Some information on
Outlook Automation is here...
http://www.granite.ab.ca/access/email.htm
 
I just finished creating such a solution. I used:

Wndows server 2003: Enable fax service, configure fax printer And share it.

Windows 2000 Pro : Install Ms Shared Fax Service. XP:Do nothing
Install the shared fax printer above.

Outlook 2003 (I think anything XP to current will work).
Configure custom outlook form to parse phone #:
Publish this form to the Inbox the form should be of the IPM.Note type.
I used the Cc line with win script behind the form itself to parse the fax #.
These are the fax # formats that worked for me:
[Fax:1234567] & [Fax:+1 1234567890]
I found tha the - in 123-4567 to be problematic but I'm not sure that this
finding isn't justs local voodoo...I believe its supposed to work with
it...anyways...

Add the ms shared fax as an email act. to outlook by selecting additional
server types & then ms shared fax transport. SET IT AS THE DEFAULT EMAIL
ACT. This will save you some headaches and you won't be able to tell the
difference.
Set Macro Security to low & check the trust all & trust vb project checkboxes
Also there is a freeware util called redemption google it....It bypasses
some of the outlook security measures that tend to muck up any automated
code. when publishing form do not check the send definition with form box &
if asked when publishing select no.

I then used docmd.acsendobject to create an email but call for the custom
form I created. this is not working code you must of course declare the
below...

set objol = createobject("Outlook.Application")
set objns = Outlook.getnamespace("MAPI")
Set obfolder = objns.getdefaultfolder(6)
Set objitems = objfolder.items
Set objmsg = objitems.add("IPM.Note.FaxSend")
'Ipm.note being the form type faxsend = my form name from above.
objmsg.display

objns = Nothing
objol = nothing
'_______________

Finally turn off automatic name checking by clicking tools>options>(I forget
1st tab anyways ... Email o.ptions> advanced email options & uncheck
Automaticall check names bvefore sending.

When user sends It will render anything office document imaging can convert
in adition to pdf files(If adobe acrobat "FULL" installed) into .tif images
and fax then using the shared fax printer.

Hope this helped Sorry to be cryptic and for typos but its late & I goota
crash.

James D.
MCSE, MCDBA


Steve Schapel said:
Worldrallyteam,

In my experience, you would need to use faxing software such as WinFax
Pro which supports programmatic control. Steve Arbagh has a utility for
this available at http://ourworld.compuserve.com/homepages/attac-cg/

However, I have also seen someone recently say that you can use Outlook
Automation, and just replace the 'To' field with a fax number in the
syntax like...
[Fax: 1234546]
I have not checked this, but may be worth a try. Some information on
Outlook Automation is here...
http://www.granite.ab.ca/access/email.htm

--
Steve Schapel, Microsoft Access MVP

I need to create a Macro in Access to send different Reports/Tables to
different fax numbers. e.g. 1 report to 1 location - Is there any way / easy
way to do this?

Thanks!
 
Back
Top