Hi,
My code currently does a normal ActiveWorkbook.SendMail
Recipients:=XX
Subject:=XX, returnreceipt:=XX
This automatically picks up "From" address from
local mailbox.
I have a second mailbox set up that is on the network. Is
there a way of
setting up emails from excel in such a way that it picks up
"From"
address from network mailbox?
Thanks in advance.
Kind Regards,
Anu.
************** IMPORTANT MESSAGE **************
The information contained in or attached to this message is
intended only for the people it is addressed to. If you are
not the intended recipient, any use, disclosure or copying
of this information is unauthorised and prohibited. This
information may be confidential or subject to legal
privilege. It is not the expressed view of the Commonwealth
Bank of Australia or any of its subsidiaries, including
Colonial First State Investments Limited, unless that is
clearly stated. Commonwealth Bank of Australia or its
subsidiaries cannot accept liability for any virus damage
caused by this message. Colonial First State Investments
Limited ABN 98 002 348 352, AFSL 23 24 68.
**************************************************
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|