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 'andrew.xx@yy.com.au' but I also have
access to send from a department address in the format 'zz@yy.com.au'.

Thanks in advance
040506


--
Andrew