Sar1973
asked on
Send a fax with VBA (Access): which string and declarations?
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.
set default printer="Fax"
activedocument.print "Recipient", "Number", ....
or with a string indicating fax IP/address, etc.
Is it possible? Thanx.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
or better yet, see my 1st post in the above link.
jaffer
jaffer
ASKER
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.
I would like to do it with code instead, like the WinFax module link you have posted. Thanx.
>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:
https://www.experts-exchange.com/questions/20574738/1000's-of-fax.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
so I gave the example of winFax :)
did a search and found a few links for the Console fax:
https://www.experts-exchange.com/questions/20574738/1000's-of-fax.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
ASKER
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.ScheduleTyp e = fstSPECIFIC_TIME
'CDate converts the time to the Date data type
objFaxDocument.ScheduleTim e = CDate("4:35:47 PM")
'Specify that the fax is to be sent at a particular time
objFaxDocument.ScheduleTyp
'CDate converts the time to the Date data type
objFaxDocument.ScheduleTim
>'Specify that the fax is to be sent at a particular time
>objFaxDocument.ScheduleTy pe = fstSPECIFIC_TIME
>'CDate converts the time to the Date data type
>objFaxDocument.ScheduleTi me = CDate("4:35:47 PM")
I am only guessing here:
omit this line:
objFaxDocument.ScheduleTyp e = fstSPECIFIC_TIME
and change this line to:
objFaxDocument.ScheduleTim e = ("4:35:47 PM")
>objFaxDocument.ScheduleTy
>'CDate converts the time to the Date data type
>objFaxDocument.ScheduleTi
I am only guessing here:
omit this line:
objFaxDocument.ScheduleTyp
and change this line to:
objFaxDocument.ScheduleTim
or try
Dim MyTime
MyTime = #4:35:00 PM#
objFaxDocument.ScheduleTim e = MyTime
jaffer
Dim MyTime
MyTime = #4:35:00 PM#
objFaxDocument.ScheduleTim
jaffer
ASKER
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.
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.
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
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
ASKER
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?
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?
Here you go:
Reports: Change printers from code
http://www.mvps.org/access/reports/rpt0009.htm
jaffer
Reports: Change printers from code
http://www.mvps.org/access/reports/rpt0009.htm
jaffer
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
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
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
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
...and I love that spell check!
;-)
Jeff
;-)
Jeff
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
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
LOL
Well Jeff, since Sar1973 didn't contact Customer Support, I did :)
jaffer
Well Jeff, since Sar1973 didn't contact Customer Support, I did :)
jaffer
Thanks
VM
Thanks for your help, always appreciated :)
The solution to use WinFax 10 was posted on:
https://www.experts-exchange.com/questions/23512317/Send-a-fax-with-VBA-Access-which-string-and-declarations.html#21876236
So I recommend selecting it as the correct answer.
jaffer
Thanks for your help, always appreciated :)
The solution to use WinFax 10 was posted on:
https://www.experts-exchange.com/questions/23512317/Send-a-fax-with-VBA-Access-which-string-and-declarations.html#21876236
So I recommend selecting it as the correct answer.
jaffer
Did you try contacting Symantec?
JeffCoachman