Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using Access & Outlook to send faxes to telephone numbers, not email

Status
Not open for further replies.

jmpWashDC

Technical User
Mar 19, 2002
35
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top