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 a few clicks, we can send an email with MS-Access Objects as an attachment to the mail. Depending on the object selected for attachment the output format options available may be different. The attachment format for the 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 the 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 use its Contact List.
Access Mail Client
Your Application may be shared by several users on different PCs, but the mails should go from the 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 the Lotus Notes Administrator for this purpose.
Configuring MS Outlook with Lotus Notes.
We will look into the MS-Outlook configuration steps now with a few images and what it does.
Your Lotus Notes ID File reference must be inserted into the 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 the Mobile Group menu of File Menu. The Location: Office (Network) control will be displayed.
Click on the Advanced Tab and select Basics from the displayed 2nd set of Tabs. See the Image below.
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 and the 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.
Close the Control after inserting the Location reference and minimize Lotus Notes.
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.
Click on the Services Tab. The Profiles window will be empty if you have not configured for any other services earlier.
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.
Click on the Delivery Tab and select Lotus Notes Message Store in the control below. At this point, you may be prompted for the Lotus Notes password to complete this option. The information Service Lotus Notes Transport will appear in the next window.
Select the 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:
Click Apply to update the settings. Click OK to close the window. You can configure the same settings from the Options of Tools Menu of MS-Outlook too.
We have to define one more setting as to how to store the Contact's Name in the Address Book, which we will do from Outlook.
Open Microsoft Outlook. Select Preferences from the Options of Tools menu.
Click on the Contact Options' button.
Select the Options in both controls as shown below and click OK.
The first control settings say 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 mail from MS-Access we must present the email ID to Lotus Notes in the first format.
The Image of the Lotus Notes Mail ID lookup control is given below for reference. I have edited the image to insert those names more familiar to you. Check the name displayed in the left window and how the name format changed when it is inserted in the To line.
You may now try to send an e-mail through Lotus Notes Mail manually from MS-Access, as we did in an earlier session, using some of your friends Lotus Notes IDs. During the mail transmitting point, Lotus Notes will prompt for the password.
Next, we will see how to send the Mail Alerts automatically from Microsoft Access through Lotus Notes at scheduled intervals.
I am using Lotus Notes 8.5.1 in Windows 7 Enterprise 64 Bit With MS Outlook 2010.
ReplyDeleteThe above procedure is not for my system.
Is there any way for me to use Outlook 2010 instead of Lotus Notes
I am still using MS-Office2007. Please pay a visit to this link on the Microsoft Outlook2010 support Page for help:
ReplyDeletehttp://office.microsoft.com/en-in/outlook-help