vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

 

Home  Contact Us
Order our Software

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

  Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

The Toolshed 
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More



The Toolbox

Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..


Access >>> SQL 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

SharePoint
For our company file sharing and task management, we use
SharePointHosting

DryToast 
Backup and query your BaseCamp
® projects
Read More


Datamining/Graphs

Explore your data with this versatile graphing and data mining shareware tool.  Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
 vb123.com.au
 

 

Next Tip  From Access to Automated E-mail (MAPI/TRANSFER  NOTES)

MAPI …  MAPI      Where Art Thou   MAPI

If you are not using Outlook or Exchange as your email system, you will first need to find out if your email is setup as a MAPI client.   I use and enjoy the multi email account features of Outlook 2002.  And I am definitely not here to convince you that any email system is better than another. 

An easy way to tell if your email software is set up as a MAPI client is to go into Access 2000+, open a report in preview mode, right click on the report and choose the Send option.  Choose the RTF format and then if you come up with figure 1, then you are using Exchange, if not then your favorite email program is your MAPI client.   If you think I am laboring this a little, I was more than a little confused myself (but that’s not unusual) when I first started setting sort of software up.

 

Figure 1 -  If you see this when doing a Send To Command, then Exchange is your MAPI client

If you wish to set up your normal email service as your default MAPI client email, check the options menu in your email system.   If you are looking for MAPI, check in your email options or search for MAPI in your help file.   Outlook Express didn't even have a MAPI reference in the help file even though it supported it in the options.

Transferring To Exchange (or Outlook)  So That You Can Use The Email Linker

Prior to using the Exchange linker, I first had to manually transfer my email messages across to Exchange.  To do this in Outlook Express, select menu option File, Export and then select the folder that you want to export to.  You will now want to ensure that MAPI has been turned off in your default email service so that you can open the MS Exchange linker.

 

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals