Send email with Outlook

[MagicMan]

Hi,

I want to send email with Excel (VB).
But I want to use the From field.

I try the .From command but not working

 

[Joel]

It would be a security issue to allow somebody e-mail to look like it came
from another users. IT IS NOT ALLOWED!!! You culd make you e-mails look
like they came from another person and then you could put a virus into the
emil. a person who thought there e-mail wasw coming from somebody they know
would not expect a virus to be in an attachment.

 

[Ron de Bruin]

You can use this

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
.SentOnBehalfOfName = """SenderName"" <[email protected]>"

You can find it on this tip page for all my Outlook examples
http://www.rondebruin.nl/mail/tips2.htm