Solved

Send a fax with VBA (Access): which string and declarations?

Posted on 2008-06-24
24
1,540 Views
Last Modified: 2013-11-27
Hi I have both WinFax 10.0 and Console Fax installed as printers; I would like to send a fax with a few lines, such as:
set default printer="Fax"
activedocument.print "Recipient", "Number", ....
or with a string indicating fax IP/address, etc.
Is it possible? Thanx.
0
Comment
Question by:Sar1973
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 5
  • 5
24 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21862833
Sar1973,

Did you try contacting Symantec?

JeffCoachman
0
 
LVL 9

Author Comment

by:Sar1973
ID: 21863304
No, since the first effort I want to do will be with Windows Fax Console; definitely I want to set the parameters of the print code line that allow to send the fax with VBA.
0
 
LVL 27

Accepted Solution

by:
jjafferr earned 75 total points
ID: 21876236
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 27

Expert Comment

by:jjafferr
ID: 21876274
or better yet, see my 1st post in the above link.

jaffer
0
 
LVL 9

Author Comment

by:Sar1973
ID: 21893605
Done it: and if I would do it with console fax? It is simply a Windows fax service that you can use by sending documents to a virtual printer; then you have to follow a dialog box in which you are required to insert fax number, recipient, etc.
I would like to do it with code instead, like the WinFax module link you have posted. Thanx.
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 21894343
>I have both WinFax 10.0 and Console Fax installed
so I gave the example of winFax :)

did a search and found a few links for the Console fax:
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20574738.html#8368672

check the VB code in link below:
http://msdn.microsoft.com/en-us/magazine/cc301661.aspx
http://msdn.microsoft.com/en-us/magazine/bb985732.aspx

http://sandlerco.com/VBScript.htm

and I am sure there are more.

jaffer
0
 
LVL 9

Author Comment

by:Sar1973
ID: 21901830
Tried both; only have a problem in scheduling Fax Service. Thse lines are not recognised:
'Specify that the fax is to be sent at a particular time
objFaxDocument.ScheduleType = fstSPECIFIC_TIME
'CDate converts the time to the Date data type
objFaxDocument.ScheduleTime = CDate("4:35:47 PM")
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 21902032
>'Specify that the fax is to be sent at a particular time
>objFaxDocument.ScheduleType = fstSPECIFIC_TIME
>'CDate converts the time to the Date data type
>objFaxDocument.ScheduleTime = CDate("4:35:47 PM")

I am only guessing here:
omit this line:
objFaxDocument.ScheduleType = fstSPECIFIC_TIME

and change this line to:
objFaxDocument.ScheduleTime = ("4:35:47 PM")
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 21902385
or try

Dim MyTime
MyTime = #4:35:00 PM#
objFaxDocument.ScheduleTime = MyTime

jaffer
0
 
LVL 9

Author Comment

by:Sar1973
ID: 21910753
I will: I am now wondering if the best way is to send a fax with Outlook, since I have a service installed.
If I set recipient address "[Fax: 123-456]" does not work; if I set "Recipient@123-456" Outlook asks me to add recipient to the address book (but I do not want to).
Is there a simple way to use this Console Fax to send a fax with email by attaching the fax document and typing somewere the fax number? Thanx.
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 21910890
Sar1973

I am sorry, but i don't have an idea about Outlook fax.

I have noticed you jumping around from one thing to another, namely WinFax 10.0, then Console Fax, and now sending fax with Outlook.

If you think none of my replies solved your question, then you can ask Customer Support to close this Q.

jaffer
0
 
LVL 9

Author Comment

by:Sar1973
ID: 21947143
The problem is that:
1)if I would use Console, I won't have the chance to schedule faxes since the commandScheduleTime is not accepted (probably because of my libraries)
2)if I would use Outlook, I am asked to charge previously the address book
I am now wondering of printing to fax printer, but I don't know how to do it with VBA: can you help please?
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 21947766
Here you go:

Reports: Change printers from code
http://www.mvps.org/access/reports/rpt0009.htm

jaffer
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21948696
jaffer,



Sorry, I did not notice that.
I did not mean to be rude and not reply.
(I'm doing fine by the way)

After you stepped in, I just sat back and watched you perform your usual magic!
;-)

Jeff
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 21951555
LOL
 
Thanks Jeff, No worries, I was sure you didn't notice my tiney note,
but now that EE has this new bold italic and underline features, things should be more visible :) (oh, they don't have emotions yet 8-)

thanks for your reply.

jaffer
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21955509
...and I love that spell check!
;-)
Jeff
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22129826
Sar1973,

You Accepted my post about Spell check?

If my post did not specifically solve your issue, you are under no obligation to Accept it.

Accepting a post closes the question.
So if anyone searching here finds this question, they will wonder why a post about "Spell Check" is the Accepted answer.

Please click the "Request Attention" button in your original post and have this corrected.

Thanks

JeffCoachman  
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 22131221
LOL

Well Jeff, since Sar1973 didn't contact Customer Support, I did :)

jaffer
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22133028
Thanks
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 22138833
VM

Thanks for your help, always appreciated :)

The solution to use WinFax 10 was posted on:
www.experts-exchange.com/Q_23512317.html#21876236

So I recommend selecting it as the correct answer.

jaffer
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question