Recent content by jelwood01

Rob, Depending how you want to display the info there are a couple of options availble. First is to pack the report info into the body of the email and send it sans attachments. The other option, which I have used for more complicated documents, is to instantiate Word and write the data and...

when you are in a module go to Tool-->References and select Microsoft Outlook 9.0. :-) jelwood01

Ah-Ha... I should have done my homework a little better! The reason behind your HTML woes is that Outlook 97 doesn't support HTMLBody as an object... Here is the link for the Map of the Outlook 97 object model: http://www.microsoft.com/OutlookDev/Articles/MapOutl8.vsd My apologies on this one...

Do you want to forward on the code that you are using to create the email? Could be a couple of things... I'm assuming that you are using Access 97... Let me know. Thanks! jelwood01

Hmm... No HTML code? Are you specifying .HTMLBody as opposed to .Body when you are building the email? That might be the root of the problem. All the same I'm glad it is working out. Outlook is a pretty powerful tool and there are some neat things you can do with tasks, calendars, and...

Here is the HTML to make a hyperlink: <a href=&quot;http://www.tektips.com&quot;>Tek-Tips</a> The first part of the tag {<a href=&quot;http://www.tektips.com&quot;>} gives the actual address. In between those tags is the lable for the link, in this example Tek-Tips. Then the closing tag...

Smiley, Are you looking to just point to the file location i.e. a shortcut? Depending on your network configuration this may or may not work. You can send a hyperlink that points to the location of a file on the network: C:\Access\Test.DOC or \\bravo\access\Test.DOC if the drives aren't named...

I just went through this myself in the past month. 1. The username and password can be added at that prompt. It wants to set up local user profiles. 2. I had some problems with my windows 98 machine regarding the .dll files relating to networking. However, it sounds like there might be a...

Try the code on this thread. It has worked for me and can be spiffed up with some loops and if...then's. thread181-75403 jelwood01

Off the top of my head I can't think of a method to access the rules. The complete object model for Outlook is here http://www.microeye.com/images/OL2Kmap.gif What is the goal of accessing the rules programmatically?

Do you mean the rules that govern how incoming mail is handled? Try htttp://www.outlookexchange.com They have the Outlook object model there, though I don't recall seeing anything about the rules wizard.

That's it! Thanks! jelwood01

I have taken a couple of crash courses in VB and SQL and found that the best way to &quot;figure it all out&quot; is to just experiment. Here are the four books that I use as references: 1. Platinum Edition: Using Access 97; Jennings; QUE 2. Access 97 Developer's Handbook; Litwin, Getz...

I have found that using an instance of Outlook is cleaner and easier than the DoCmd method. If you have varying numbers of attachments you can create a text box to enter in the file name and location, a button to add the information to a list box, then a button that will loop through the info...

I jumped the gun.... I just worked it out: Dim appOutLook As Outlook.Application Dim objNameSpace As NameSpace Dim objfolder As MAPIFolder Dim stText As String Dim stMinute As String stMinute = Text3 * 60 ' convert hours to minutes Set appOutLook =...