Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to read a Word file into outlook email body via access vba

Status
Not open for further replies.

Baggie

Technical User
Jun 11, 2002
25
US
Hello all,
I have borrowed some code from thread 705-1367295 which shows how to send an email via Outlook from Access. I am having trouble with one item so far and that is where the program declares this variable:
Dim fso As FileSystemObject
I get a compile error: User-defined type not defined.

Is that something I need to set in the reference library and if so what is it?

Once I get past that I'm hoping that it works to read in an HTML body from a Word document.

If someone has a better suggestion I would welcome that as well. This is the first time I've tried to control the Outlook object
 
Set a reference to the Microsoft Scripting Runtime.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
 
Greg,
That did it! Thanks so much!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top