Hi
I am need to use Access to send faxes to fax numbers normally found in and our Oulook files.
When I do this in Outlook, I choose a person to fax to from the address book and Outlook underlines the data (ABC Business Fax) so I know that Outlooks knows that it has to dial a fax machine rather than send an email
So how do I get that information into Access so I can use it to send faxes with VBA code
I have a linked table to Outlook, a query of that table for necessary data
but now I'm stuck
Dim FaxNumber As Variant
...
Do While rs.EOF = False
FaxNumber = FaxNumber & rs![E-mail address] & ";"
rs.MoveNext
Loop
DoCmd.SendObject acSendNoObject, , ,FaxNumber, , , , , , True
I know this code works if FaxNumber is any string of names and it reads easy characters for [E-mail address].
but I need FaxNumber to be a string of telephone number that look like email address. Is that some kind of SMTP thing?
thanks!
jmp
I am need to use Access to send faxes to fax numbers normally found in and our Oulook files.
When I do this in Outlook, I choose a person to fax to from the address book and Outlook underlines the data (ABC Business Fax) so I know that Outlooks knows that it has to dial a fax machine rather than send an email
So how do I get that information into Access so I can use it to send faxes with VBA code
I have a linked table to Outlook, a query of that table for necessary data
but now I'm stuck
Dim FaxNumber As Variant
...
Do While rs.EOF = False
FaxNumber = FaxNumber & rs![E-mail address] & ";"
rs.MoveNext
Loop
DoCmd.SendObject acSendNoObject, , ,FaxNumber, , , , , , True
I know this code works if FaxNumber is any string of names and it reads easy characters for [E-mail address].
but I need FaxNumber to be a string of telephone number that look like email address. Is that some kind of SMTP thing?
thanks!
jmp