codetoad.com
  ASP Shopping CartForum & BBS
  - all for $20 from CodeToad Plus!
  
  Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM 
Search Site:



Home » Visual Basic » Article

Automate Outlook Via ADO

Article by: Brian Gillham (8/24/2002)
Bookmark us now! Add to Favourites
Email a friend!Tell a friend
Sponsored by: Neil Matthews Hypnotherapy, Wilmslow
Summary: Access any of the folders of Outlook from within your Visual Basic project
Viewed: 18941 times Rating (2 votes): 
 2.5 out of 5
 Rate this Article  Read Comments  Post Comments

Automate Outlook Via ADO



If you need to use Outlook in your application you can use this code as a starting point. It is an easier alternative to using the Outlook Object Model and trying to understand what it is all about. With very few changes you can access ANY of the folders in Outlook

Select All Code







CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums
Rate this article:     Poor Excellent
View highlighted Comments
User Comments on 'Automate Outlook Via ADO'
Posted by :  Archive Import (Frank) at 15:58 on Friday, December 20, 2002
How can i dtermine which is the right folder for the address book?
I have to automate outlook 2000, someone have an idea for the connection string?
Posted by :  Archive Import (Henry) at 00:03 on Tuesday, February 11, 2003
Outlook 2000 uses the object model.
The example given is based on the type library used by Outlook Express.
If you want to automate outlook 2000 you can/must use CreateObject("Outlook.Application")
Posted by :  Archive Import (Krushna Kumar) at 06:32 on Saturday, August 02, 2003
Can I add a new contact using the recordset defined for outlook 97. It says might be limitation of the provider
========================================
.AddNew
.Fields("E-Mail address") = "someone@somedomain.com"
.Update
.Close

=======================================
Posted by :  Archive Import (SasKost) at 21:04 on Wednesday, August 13, 2003
Please help!

I have to use Data from MS SQL2000 in my Outlook (application).
How I can access any of the folders in SQl Server from my Outlook Forms ??


To post comments you need to become a member. If you are already a member, please log in .

 



RELATED ARTICLES
Generate License Keys (such as CD keys on Microsoft software)
by Brian Gillham
This class allows you to generate license keys, such as the CD keys on the case of most Microsoft software
Visual Basic Read and Modify the Registry
by Kenneth Ives
Perform the four basic functions to the Windows registry. Add, change, delete, and query. Allows you to to read registry values, and modify both keys and values.
Communicating with the Database (Using ADO)
by Chaudhary Pradeep K. Roy
Using ADO to get connected with the database.
Generate an Array of Unique Random Numbers
by Brian Gillham
This function will generate an ARRAY of TRULY random numbers.
Beginning Resource Files in Visual Basic
by Kenneth Ives
Have you ever wanted to use graphics, such as icons, bitmaps, cursors, and AVI files? How about sound or even message box text? This can be an enormous amount of overhead. These are all examples of more files to keep track of when you distribute an application, DLL, or OCX. Lets find out how resource files can help....
Visual Basic Compact/Repair Access Database Utility
by Kenneth Ives
This utility will compact and repair the access database you select. It is actually more convenient to use this utility than do the same task with Access, because you don't have to save the database with a different name and then delete the old database when you are done: here, a temporary copy of the database is automatically created and deleted.
Creating a watermark in Excel with VBA
by Kenneth Ives
Adding a watermark to an Excel spreadsheet using VBA.
Generate your own Random Numbers
by Thaha Hussain
This simple program generates random numbers using the basic mathematical methods.
Change Cursor to Hour Glass
by Brian Gillham
A simple script to change the cursor to an hour glass.
Analog Clock
by Thaha Hussain
This program demonstrates Thaha Hussain's Clock Work Formula to paint an Analogue Clock.








Recent Forum Threads
• Re: Help Running VB script in Windows 2003
• ONUNLOAD
• Re: Insert Contents of .txt file into a .html page
• Re: Perl regular expression problem.
• Re: Problems in login using WWW::Mechanize
• searching for gd::graph guide
• Re: ARRAY OF HASHMAPS
• Adv. Regexp or Otherwise
• Adv. Regexp or Otherwise


Recent Articles
ASP GetTempName
Decode and Encode UTF-8
ASP GetFile
ASP FolderExists
ASP FileExists
ASP OpenTextFile
ASP FilesystemObject
ASP CreateFolder
ASP CreateTextFile
Javascript Get Selected Text


© Copyright codetoad.com 2001-2008