473,320 Members | 2,035 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Automate faxing in VB VBA from MS Access

Does anyone have working code to send a fax from VBA using Outlook.Mailitem?
I have tried some examples I have found and they all simply try to use the
Fax number as an e-mail address.

Thanks in advance
Nov 12 '05 #1
6 5574
do you have fax service running on the machine ?
what are you running 98, xp ??
somewhere I've got code that will work with winfax, if thats what you want to do

"John Galt" <js**@yahoo.com> wrote in message news:<5_*********************@news1.epix.net>...
Does anyone have working code to send a fax from VBA using Outlook.Mailitem?
I have tried some examples I have found and they all simply try to use the
Fax number as an e-mail address.

Thanks in advance

Nov 12 '05 #2
Actually I just have the MS Fax service installed with XP.
Is there some way to just "print to the fax"?

"Roger" <le*********@natpro.com> wrote in message
news:8c**************************@posting.google.c om...
do you have fax service running on the machine ?
what are you running 98, xp ??
somewhere I've got code that will work with winfax, if thats what you want to do
"John Galt" <js**@yahoo.com> wrote in message

news:<5_*********************@news1.epix.net>...
Does anyone have working code to send a fax from VBA using Outlook.Mailitem? I have tried some examples I have found and they all simply try to use the Fax number as an e-mail address.

Thanks in advance

Nov 12 '05 #3
You need Winfax installed so it can be selected in the Printer selection dialog.

Open your report in design view. Open the Printer select dialog and set to print
to WinFax then save the report. Next, create a command button on your form that
prints the report. When pushed, the report will not even open. What will open is
WinFax; then just fill in the fax number information and send.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John Galt" <js**@yahoo.com> wrote in message
news:ic*********************@news1.epix.net...
Actually I just have the MS Fax service installed with XP.
Is there some way to just "print to the fax"?

"Roger" <le*********@natpro.com> wrote in message
news:8c**************************@posting.google.c om...
do you have fax service running on the machine ?
what are you running 98, xp ??
somewhere I've got code that will work with winfax, if thats what you want

to do

"John Galt" <js**@yahoo.com> wrote in message

news:<5_*********************@news1.epix.net>...
Does anyone have working code to send a fax from VBA using Outlook.Mailitem? I have tried some examples I have found and they all simply try to use the Fax number as an e-mail address.

Thanks in advance


Nov 12 '05 #4
I have a fax installed. It is called fax.
I want to automate a coverpage and scan thru my outlook contacts and send a
fax automatically.

"PC Datasheet" <sp**@nospam.spam> wrote in message
news:fK******************@newsread1.news.atl.earth link.net...
You need Winfax installed so it can be selected in the Printer selection dialog.
Open your report in design view. Open the Printer select dialog and set to print to WinFax then save the report. Next, create a command button on your form that prints the report. When pushed, the report will not even open. What will open is WinFax; then just fill in the fax number information and send.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John Galt" <js**@yahoo.com> wrote in message
news:ic*********************@news1.epix.net...
Actually I just have the MS Fax service installed with XP.
Is there some way to just "print to the fax"?

"Roger" <le*********@natpro.com> wrote in message
news:8c**************************@posting.google.c om...
do you have fax service running on the machine ?
what are you running 98, xp ??
somewhere I've got code that will work with winfax, if thats what you
want to do

"John Galt" <js**@yahoo.com> wrote in message

news:<5_*********************@news1.epix.net>...
> Does anyone have working code to send a fax from VBA using

Outlook.Mailitem?
> I have tried some examples I have found and they all simply try to
use the
> Fax number as an e-mail address.
>
> Thanks in advance



Nov 12 '05 #5
yup.. thats what you need
and you need to add the fax service to the mail profile that you're
going to use with Outlook

and there's a prefix to the fax number (I think it's a '+' sign) that
tell mapi to send it as a fax ... let me do some digging and I'll post
back later

"John Galt" <js**@yahoo.com> wrote in message news:<ic*********************@news1.epix.net>...
Actually I just have the MS Fax service installed with XP.
Is there some way to just "print to the fax"?

"Roger" <le*********@natpro.com> wrote in message
news:8c**************************@posting.google.c om...
do you have fax service running on the machine ?
what are you running 98, xp ??
somewhere I've got code that will work with winfax, if thats what you want

to do

"John Galt" <js**@yahoo.com> wrote in message

news:<5_*********************@news1.epix.net>...
Does anyone have working code to send a fax from VBA using Outlook.Mailitem? I have tried some examples I have found and they all simply try to use the Fax number as an e-mail address.

Thanks in advance

Nov 12 '05 #6
I did get it going.
I found a web page that detailed the adding of the fax transport to the
e-mail accounts of outlook.
I did that a "lo and behold" it worked.

BTW the format of the fax number MUST be +1 (888) 555-1212 (All spaces
and dashes and parenthesis) or it will not invoke the fax transport.

Thanks for your help.
"Roger" <le*********@natpro.com> wrote in message
news:8c**************************@posting.google.c om...
yup.. thats what you need
and you need to add the fax service to the mail profile that you're
going to use with Outlook

and there's a prefix to the fax number (I think it's a '+' sign) that
tell mapi to send it as a fax ... let me do some digging and I'll post
back later

"John Galt" <js**@yahoo.com> wrote in message

news:<ic*********************@news1.epix.net>...
Actually I just have the MS Fax service installed with XP.
Is there some way to just "print to the fax"?

"Roger" <le*********@natpro.com> wrote in message
news:8c**************************@posting.google.c om...
do you have fax service running on the machine ?
what are you running 98, xp ??
somewhere I've got code that will work with winfax, if thats what you
want to do

"John Galt" <js**@yahoo.com> wrote in message

news:<5_*********************@news1.epix.net>...
> Does anyone have working code to send a fax from VBA using

Outlook.Mailitem?
> I have tried some examples I have found and they all simply try to
use the
> Fax number as an e-mail address.
>
> Thanks in advance

Nov 12 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: MCL | last post by:
Anybody done this before... I have found a few through web searches but not many... Anybody know of a com object or anything that interfaces with ASP to allow the faxing of messages and web...
0
by: Alex Stevens | last post by:
Hi All, We are looking for a faxing component, which we can drop into an application which would allow the user to send faxes through a faxmodem attached or a shared network modem. We've...
4
by: Bob | last post by:
I was wondering what would be the easiest way to fax a document from within a Windows .NET application. It's not enough to simple print to a fax service device. I want to be able to pass the fax...
3
by: Brad Burke | last post by:
From a windows .Net app, I need to 1) check if MSAccess is already open to a certain Access application. If so, then open a form and find a certain record. 2) If not open, then open MSAccess and...
4
by: Chris via AccessMonster.com | last post by:
I have the challenge of needing to automate table creation. It doesn't end there the tables have to be created from one table that looks something like this... Email ...
16
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use...
2
by: Joan | last post by:
Hi all I want to send a fax with WebService in vb.net; I use this code to send a fax with FaxService in Windows XP Dim FXServ As New FAXCOMLib.FaxServe Dim FXDoc As FAXCOMLib.FaxDo Dim iFaxJob...
2
by: willl69 | last post by:
Hi, I was just wondering if anyone knows if its possible to set up some sort of remote faxing server using PH P & apache. If not, any other prog languages or server technologies? I know .NET...
0
by: crazytegger | last post by:
Hi, I have an access report that has 2 different images on it. One is embedded, and one is a linked image. The report prints to a local printer just fine. When I try to fax the report (using WinFax)...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.