Help Sending an email with the "from field" pre-completed

[Rulke]

Hoping I can make my life at work easier, we have to send a lot of emails to a lot of different addresses from a shared mailbox. Is it possible to set up a mailto: link (ie in excel/word) that fillls in the From field with an address of my choosing?

 

[old.Osy]

http://www.howto-outlook.com/howto/mailmerge.htm

 

[Rulke]

I bodged together some VBA and it seems to work - thanks though