So I am just start to use VBA but I noticed that it is both in Excel and
Outlook. So does that mean you can write a macro in Excel to say send an
e-mail through Outlook.

It is definitely possible. Check out this link:
http://www.rondebruin.nl/sendmail.htm

Hope this helps,

Hutch

"Chad Portman" wrote:

So I am just start to use VBA but I noticed that it is both in Excel and
Outlook. So does that mean you can write a macro in Excel to say send an
e-mail through Outlook.

You can use VBA with any Microsoft commercial product. Some are easier than
others to become proficient in. A lot of the Outlook syntax is the same as
the Word syntax. Both Word and Outlook have considerably different constants
than Excel, which makes sense because they serve different purposes. Access
has yet another set of constants but has some similarity to Excel. You could
spend a lot of time learning to use them all. But if you pick one version
and learn it, you can make use of it to work in the others.

"Chad Portman" wrote:

So I am just start to use VBA but I noticed that it is both in Excel and
Outlook. So does that mean you can write a macro in Excel to say send an
e-mail through Outlook.

Oh, and yes, Excel has a SendMail feature that allows you to send Email from
Excel.

"Chad Portman" wrote:

So I am just start to use VBA but I noticed that it is both in Excel and
Outlook. So does that mean you can write a macro in Excel to say send an
e-mail through Outlook.