Emailing from nominated email address
 

Hi,

I have code that allows Excel to send email via Outlook (2000 SP-3) . It
works fine but I can't find how to nominate what the 'From' address should be.

By default it is sent in the format ' but I also have
access to send from a department address in the format '.

Thanks in advance
040506


--
Andrew