Search results for query: *

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

Bastien, Do you know of a method by which a user can update that task from Access? I have been able to create new tasks, and import all tasks into the dB but have not been able to successfully update one with data from the dB. I have looked at the ActiveInspector Method, GetInspector property...

Doug, It is an either/or situation for the body of the message. I prefer to use .HTMLBody for the flexibility it offers. I use the BarebonesHTML as a style guide because HTMLBody allows you to do all sorts of neat formating with colors, font sizes, etc. The first code that you list looks good...

The position property determines where the file is placed. I suppose that if you have an input box to fill in the body of the message you could count the number of characters (spaces included) add one to resulting number and use this value in the position property. In the first code below I...

After a little fiddling the only pieces that I can grab are names, emails, and class. There should be a way to access the info about the individual. It might be contained somewhere else and the .details pulls that up based on a relation to the ID of each individual. I'll keep digging to pull...

Well, I have found a couple of ways to obtain, update, and manipulate data out of Outlook. There should be a way to dim an object say objAddress as Addresslist. I think that this would call up the global address list. There are two available Addresslist and Addresslists. Below is the code...