Email

[NeilGel]

Hi,

In MS Outlook, you can specify who an email is from. Is there a way to use
VBA to send an Email, where you can also specify the:

From:
To:
CC:
BCC:

When creating the email?

Thanks

 

[Daniel]

Take a look at

http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

it should provide you with all the expanations you require.

 

[Dirk Goldgar]

In

Hi,

In MS Outlook, you can specify who an email is from. Is there a way
to use VBA to send an Email, where you can also specify the:

From:
To:
CC:
BCC:

When creating the email?

You can use DoCmd.SendObject, or you can use Outlook automation. Both
methods will allow you to set To:, CC:, and BCC: recipients for the
message. You can't specify From: when using SendObject -- it will use
your default e-mail account. You may be able to do it when automating
Outlook; I don't know.