Open 'new email' in outlook (using word as editor, as per normal)

[calum112 via AccessMonster.com]

I have a field in each record of a continuous form that contains an email
address. There is a command button next to it which, when clicked, should
open outlook to email that address. Like what happens in a normal email
hyperlinks

I can see two ways of doing this:

1) Turn the field to a hyperlink.
This works perfectly, however it makes it a pain to edit the link.

2) Use the sendobject command in VBA / a macro.
Again: This works, however unlike the above it opens the new message directly
in outlook instead of using word as the email editor as per outlook settings??


Can anyone shed any light on this?

Thanks

p.s. It's office 03, if that makes a difference.

 

[calum112 via AccessMonster.com]

I was just woking on a hyperlink and I thoguht I'd try the following (and it
worked):


Private Sub Command32_Click()

Dim strLinkPath As String

strLinkPath = "mailto:" &

Application.FollowHyperlink address:=strLinkPath, NewWindow:=True



End Sub