Learn Microsoft Access Advanced Programming Techniques, Tips and Tricks.

Configure Outlook for Lotus Notes

Continued from earlier Post: MS-Access and Emails

We have seen that sending EMails from MS-Access is easy enough like any other method you are familiar with. With few clicks we can send an email with MS-Access Objects as attachment to the mail. Depending on the object selected for attachment the output format options available may be different. The attachment format for VB Code module is Text format only and will be converted into this format before attaching it to the mail.

As I have pointed out in the earlier post that we can send Mail Alerts automatically on important matters, within the Local Area Network (LAN) through Email Transport Services like Lotus Notes, from our Access Application.

But before we look into the mail sending procedure and Programs, we must configure MS-Outlook on one of the PCs for Lotus Notes and to use its Contact List.

Your Application may be shared by several Users on different PCs but the mails should go from only Machine, let us call it Access Mail Client. We need to configure the Access Mail Client Machine for Lotus Notes. Lotus Notes has its own Mail Server and Client installations on each PC. The Access Mail Client machine also must be installed with Lotus Notes Client and you must be using it for sending emails directly from Lotus Notes. You will have a Unique Lotus Notes ID File on your PC besides your own contact Lotus Notes Mail ID.

NB: If you don't want a personal User Id to appear as the Sender of the Mail Alerts from your Access Application then a special Lotus Notes Mail ID must be created and Lotus Notes Client must be installed with this ID on the Access Mail Client machine. You may seek the help of Lotus Notes Administrator for this purpose.

We will look into the MS-Outlook configuration steps now with few images and what it does.

  1. Your Lotus Notes ID File reference must be inserted into a control within Lotus Notes itself to be visible to the external Programs like MS-Outlook to use the facilities provided by Lotus Notes. To do this, open Lotus Notes and Log in with your User Id and password. Select Edit Current Location . . . from Mobile group menu of File Menu. The Location: Office (Network) control will be displayed.

  2. Click on the Advanced Tab and select Basics from the displayed 2nd set of Tabs. See Image below.

  3. Click on the Text control to the right of the label User ID to switch to: and click on the Search Light icon underneath the User ID label to browse to the location of your User ID file. The Path will be X:\Lotus\Notes\Data\filename.id, where X stands for the Lotus Notes installed Drive and the file name may have some similarity to your name depending on what name your Administrator has given with the file extension .id. Find this file and insert it into the Text control. Your Lotus Notes email Id, password are stored in this file. MS-Outlook needs this information to access the Contact List as well as to send and download the emails from Lotus Notes.
  4. Close the Control after inserting the Location reference and minimize Lotus Notes.
  5. Open Control Panel from Start Menu - - > Settings . . . and double click on the Mail Icon to display the Control with Services, Delivery & Addressing Tabs. See the image below. If your MS-Outlook installed version is not Corporate or Workgroup then the Options may look different. The images are from MS-Office 2000 installation.

  6. Click on the Services Tab. The Profiles window will be empty if you have not configured for any other services earlier.
  7. Click on the Add. . . Button to open up the Add Services to Profile list with several options. Select Lotus Notes Mail from the list and click to add it to the Profile window.
  8. Click on the Delivery Tab and select Lotus Notes Message Store in the control below. At this point you may be prompted for Lotus Notes password to complete this option. The information Service Lotus Notes Transport will appear in the next window.

  9. Select Addressing Tab on the Control. You may Select the Lotus Notes Main Address Book or your personal Lotus Notes Address Book with selected Addresses from the Main one and insert it in the appropriate controls. See the image below:

  10. Click Apply to update the settings. Click OK to close the window. You can configure the same settings from Options. . . of Tools Menu of MS-Outlook too.
  11. We have to define one more setting as how to store the Contact's Name in the Address Book, which we will do it from Outlook.
  12. Open Microsoft Outlook. Select Preferences from Options. . . of Tools menu.
  13. Click on the Contact Options. . . button.
  14. Select the Options in both controls as shown below and click OK.

    The first control settings says that while sending mails insert the Names in this order but while storing the values in the Address Book use the format in the second control.

    When you look for the Email addresses manually in the Address Book it will be displayed in the second format and you can search for the names by typing the first few characters of the first name in the lookup control.

    But when we attempt to send mails from MS-Access we must present the email ID to Lotus Notes in the first format.

    Image of the Lotus Notes Mail ID look up control is given below for reference. I have edited the image to insert those names more familiar to you. Check the name displayed at the left window and how the name format changed when it is inserted in the To line.

  15. You may now try to send an e-mail through Lotus Notes Mail manually from MS-Access, as we did in earlier session, using some of your friends Lotus Notes ID. During the mail transmitting point Lotus Notes will prompt for password.

Next we will see how to send the Mail Alerts automatically from Microsoft Access through Lotus Notes at scheduled intervals.



  1. I am using Lotus Notes 8.5.1 in Windows 7 Enterprise 64 Bit With MS Outlook 2010.
    The above procedure is not for my system.
    Is there any way for me to use Outlook 2010 instead of Lotus Notes

  2. I am still using MS-Office2007. Please pay a visit to this link on the Microsoft Outlook2010 support Page for help:



Subscribe in a reader
Your email address:

Delivered by FeedBurner


Popular Posts

Search This Blog

Blog Archive

Powered by Blogger.


Forms How Tos Functions MS-Access Security Reports msaccess forms Animations msaccess animation Utilities msaccess controls Access and Internet MS-Access Scurity MS-Access and Internet Queries External Links msaccess reports msaccess tips Accesstips Array Menus and Toolbars MsaccessLinks Process Controls Art Work Class Module Downloads msaccess How Tos Graph Charts Objects msaccessQuery Combo Boxes List Boxes Property VBA Collection Object Command Buttons Data Emails and Alerts Query Calculation Custom Wizards DOS Commands Data Type Dictionary Object ms-access functions msaccess functions msaccess graphs msaccess reporttricks Command Button Object Reference msaccessprocess security advanced Access Security Add Controls Custom Functions Field Type Form Form Instances Item Key Macros Menus Report Top Values Variables msaccess email msaccess menus progressmeter Access2007 Auto-Number Copy Event Expression Fields Join Methods Microsoft Numbering System Records Recordset Security Split SubForm Table Time Difference Utility WithEvents Workgroup Wrapper Classes database msaccess wizards tutorial Access2003 Accounting Year Action Animation Attachment Binary Numbers Bookmarks Budgeting ChDir Color Palette Conditional Formatting Data Filtering Defining Pages Diagram Disk Dynamic Lookup Error Handler Excel Export External Filter Formatting Groups Hexadecimal Numbers Import Labels List Logo Macro Mail Merge Main Form Memo Monitoring Octal Numbers Operating System Paste Primary-Key Product RaiseEvent Rank Reading Remove Rich Text Sequence SetFocus Summary Tab-Page Tables Union Query User Users Water-Mark Word automatically commands function hyperlinks iSeries Date iif ms-access msaccess msaccess alerts pdf files reference restore switch text toolbar updating upload vba code

Featured Post

WithEvents and Defining your own Events

Hope that you have gone through last week’s WithEvents, Event, RaiseEvent introduction, tried out the sample Forms and understood as how bo...


Blog Archive

Recent Posts