Beginner VBA user asking advanced questions

C

Chad Portman

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.
 
J

JLGWhiz

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.
 
J

JLGWhiz

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