Hyperlink in google sheets that opens up a specific outlook email template -


i assistance matter i've been able regular email open directly sheets when inserting e-mail hyperlink.

the current code have =hyperlink("mailto:@gmail.com&subject=test&body=test%0aand%0atest%202", "email").

i need way link open specific outlook email templates located on desktop.

thank light can shed on subject.

best, -ed

there no way job done.

if use internet explorer may consider automating outlook script. solution not work in other browsers. see compose , send e-mail javascript using outlook automation 2007 more information.

the possible solution browsers use mailto: protocol opening pre-filled new mail item.


Comments