How to insert TO; fields with Emailaddress?

[petrovlis]

I have Msaccess emailfield xxxx@yyyyy with cmdbutton to
press to start Outlook.It works fine,however in the TO:
field of the pop-up Outlook message box I have to fill in
by hand the email address.

Also to press toolbar "insert' to get my signature in the body text.

Code is now:

Private Sub cmdEmail_Click()
DoCmd.SendObject acSendNoObject, , , Me.Email
End Sub

I like to have also in the text body my default signature.
( I have set in Outlook Signature as default,but in the popup Outlook screen NO such Signature visible.

I like to fill in automatically the Subject:e.g."Reply Email".


Thanks for the help

William Rippen

 

[Mike555]

Take a look at the help file SendObject Method in Visual Basic Help.

To Specify the Subject:
DoCmd.SendObject acSendNoObject,"Subject Goes Here in quotes" , , Me.Email

In regards to your e-mail signature, this is a bit difficult. It looks like the only way you can insert this is by specifying it in the MessageText argument.

HTH.

--
Mike