Use Yahoo email, when we click from the form

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

This is my VBA on the email button, but it runs to open MS Outlook 2007
email progtram. How can we make it to always open an Yahoo. email program, or
whatever available program in smeone's computer.

Private Sub cmdEmail_DblClick(Cancel As Integer)
On Error GoTo HandleErr

' Save the record
If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord

' Make sure the hyperlink property is current
EnableEmail

' We don't actually have to do anything here. The button uses its own
' hyperlink property to send mail, as specified in the Form_Current

ExitHere:
Exit Sub

HandleErr:
Select Case Err
Case Else
MsgBox Err & ": " & Err.Description, _
, "Form_Contact.cmdEmail_Click"
End Select
Resume ExitHere
End Sub

Thanks for anyhelp.

Frank
 
Frank Situmorang said:
Hello,

This is my VBA on the email button, but it runs to open MS Outlook 2007
email progtram. How can we make it to always open an Yahoo. email program,
or
whatever available program in smeone's computer.

Private Sub cmdEmail_DblClick(Cancel As Integer)
On Error GoTo HandleErr

' Save the record
If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord

' Make sure the hyperlink property is current
EnableEmail

' We don't actually have to do anything here. The button uses its own
' hyperlink property to send mail, as specified in the Form_Current

ExitHere:
Exit Sub

HandleErr:
Select Case Err
Case Else
MsgBox Err & ": " & Err.Description, _
, "Form_Contact.cmdEmail_Click"
End Select
Resume ExitHere
End Sub

Thanks for anyhelp.

Frank
Click to expand...
 
Frank Situmorang said:
This is my VBA on the email button, but it runs to open MS Outlook 2007
email progtram. How can we make it to always open an Yahoo. email program, or
whatever available program in smeone's computer.
Click to expand...

Does Yahoo have their own email client software or do you use a web
page? If it's a separate installable exe file which runs on your PC
then it should also register itself as the default email provider.

If a web page such as Hotmail, Gmail or whatever then you could ask
the user if they use such an account and then open the appropriate URL
for them to login.

Hmm, it is possibly that you can fill data in on a web page and get it
to process the data. However I have no idea how to do that.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Frank said:
Hello,

This is my VBA on the email button, but it runs to open MS Outlook
2007 email progtram. How can we make it to always open an Yahoo.
email program, or whatever available program in smeone's computer.
Click to expand...

If they are all running windows then Outlook express is your best bet.
Finding anotehr free client and running that would be second.
After that you will be having problems that will go on endlessly.
To start you will have to find a way to write code that will conditionally
log into sites and send your mail.
I'd switch to Autoit to start then to a more robust solution down the road.
 
Frank Situmorang said:
' We don't actually have to do anything here. The button uses its own
' hyperlink property to send mail, as specified in the Form_Current
Click to expand...

SendObject might give you more, although limited, options when sending
email.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top