SendMail to FAX office2010

[suzana_y]

Hi,
I have vba application that send letters by fax or mail from excel with :
ActiveWorkbook.SendMail "[FAX:" & fax_num & "]"

before office 2010 it worked with no problem...
now when i try to send fax with this program, the outlook convert the string from "[FAX:12345678]" to "12345678", and the message could not be sent without the prefix "[FAX:"

How can I fix the problem??
Thanks
Suzana

[abousetta]

Hello Suzana and welcome to the forum,

Can you show us the vba code so we can see why it is doing this?

[suzana_y]

The problem with "SendMail" command..

there is part of the code..... send_type=1 is fax, 2 is mail:
fax_num it is from DBAccount data..

If send_type = 1 Then
Application.Wait 2
If tel_type = 1 Then
ActiveWorkbook.SendMail "[FAX:" & ext & "," & fax_num & "]"
ElseIf tel_type = 2 Then
ActiveWorkbook.SendMail "[FAX:" & fax_num & "]"
End If
ElseIf send_type = 2 Then
ActiveWorkbook.SendMail mail_add, "Bank transform"
End If

I hope it will help to understand the problem..
Suzana

[abousetta]

Hi,

Please use code tags around your code as it makes it easier to read. Also I don't see the problem from the snippet you posted except for a syntax error which is probably just means that this is a selection of different parts of your code. I am assuming that you are using the SendMail add-in written by Ron de Bruin. Could you upload an example workbook with dummy data?

[abousetta]

OK. I see your problem when I downloaded an example file from Ron's site. Let me play around with it and will let you know if I find a workaround.

[abousetta]

I see the problem and I don't think there is a solution available with Outlook 2010. The problem is that the program automatically will remove the first 'null' characters which you want to keep and I don't see any way to force the program not to check the email address.

[suzana_y]

Thanks!
Maybe there is another command that I can use for sending by fax?
It have to be with no modem and free..
Suzana

[abousetta]

If you have the Microsoft Shared Fax Driver (Fax printer) set up on your computer, this article should help.

[abousetta]

This article is specific to Excel vba and should also be of help.

[suzana_y]

Thanks!
I will try with the second article!