email field access, how do I send email through Outlook

[Guest]

I have an Access 2003 field "email address", How do I set it so when I click
on the email field from the "FORM", it opens up Outlook 2003 new message
email form so I can type a message or send an attachment.

 

[Al Campagna]

trainref,
Check out the SendObject Method.
In the TO argument, you can refer to the form's email field for that value.
DoCmd.SendObject , , , , Me.EmailField
as well as other aspects of the email...

 

[pietlinden]

trainref,
Check out the SendObject Method.
In the TO argument, you can refer to the form's email field for that value.
DoCmd.SendObject , , , , Me.EmailField
as well as other aspects of the email...
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Al,
Not sure I follow. I think the OP has to automate Outlook, because he
wants to basically create a new message that he can fill in.

I think you have to...
1. use fIsAppRunning() from Accessweb to determine if Outlook is
running.
2. create a new message.
3. assign the recipient's e-mail
4. Display the message.

 

[Ron2006]

You can also put the following code in the onDblClick event of the
email field

application.followhyperlink "mailto:" & me.emailaddresfieldname

Ron

 

[Al Campagna]

I don't use Outlook (I use Oulook Express), but SendObject should work with your
Windows default MAPI Email application.
Just...
DoCmd.SendObject
is all that's needed to open the default email app with only a FROM (the default email
address), filled in and the user can eneter any message they want. There's no TO, or MSG
or CC, etc... but the SendObject arguments allow for customizatuion of those parameters.

I should not be any different with OutLook, or any other MAPI compliant email app,
registered as Default under Windows.

Check out Google Groups for Access "SendObject" "Outlook". There are many instances of
SendObject and Outlook questions and answers.