Open outlook with To field from Excel vba -


i want open outlook compose email window field filled.

in c#, if write "mailto:abc@abc.com", open compose email window field.

is possible using excel vba?

the vba hyperlinks.add method want (see https://msdn.microsoft.com/en-us/library/office/ff822490.aspx).

... activesheet     .cells(4,4).value = "someone@somewhere.com"     .hyperlinks.add anchor:=.cells(4, 4), _     address:="mailto:someone@somewhere.com" end 

Comments