Outlook VBA Beginner Questions

[pengrbt]

Hi, folks, I am new here and I am a complete beginner in VBA programming, though I am a computer science grad student.

I have a very basic question: can Access macro be used in Outlook directly and vice versa?

My current goal is to write a macro for Outlook 2000 to send an email while the body of the email is from a text file. I am going to have some books on vba soon but I think maybe I can get better answers here.

Thanks in adv for any help you can give me, sincerely, -Pengrbt

 

[SkipVought]

Hi,

Each MS Application has its own Objects with its properties & Methods. VB is VB, but any VB that references Access Objects cannot be used in Outlook.

If you have a VB procedure for Access that uses Outlook Objects, the programmer set a reference in Tools/references to a MS Outlook Object Library, instantiated an Outlook Application Object etc. Those things would NOT need to be done from Outlook. If, from Outlook, you were to need to access MS Access Objects, you would need to set a reference to the MS Access Object Library and instantiate an Access Application Object etc.

Hope this helps.

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]