Excel Email Macro - "From" Address.

[SkiBumScot]

Hi,
I have been using a slightly adapted version of the code at this
link:

http://j-walk.com/ss/excel/tips/tip86.htm


Working great but now need to send on behalf of a group email account
so need to add the "From" address in the URL line.


Can anyone please advise of a good approach to this?


Thanks

 

[Karl E. Peterson]

I have been using a slightly adapted version of the code at this
link:

http://j-walk.com/ss/excel/tips/tip86.htm

Working great but now need to send on behalf of a group email account
so need to add the "From" address in the URL line.

Mailto: URLs don't actually send anything. All they do is pop up a new
email composer using the default email application. As such, it would be up
to the email application whether or not it accepted such a parameter. (As
only Outlook accepts attachments this way.) I'm not aware of any apps with
this support. IOW, you need a different plan.