Question and collection

"You begin with the Collect Data Through E-mail Messages Wizard, which guides you through the steps of creating a form.

The form is sent through Microsoft Office Outlook 2007-10 to your recipients, with your request for new or updated information.

When the recipients reply to your message, Access automatically enters their data into your database.

Labels: E-mail, Forms, General, Internet, Reference, Shortcuts, Tips, Tutorials

Automate the drill

"You can use the SendObject method to send a MAPI mail message programmatically in Microsoft Access. However, the SendObject method does not give you access to complete mail functionality, such as the ability to attach an external file or set message importance.

The example that follows uses Automation to create and send a mail message that you can use to take advantage of many features in Microsoft Outlook that are not available with the SendObject method.

There are six main steps to sending a Microsoft Outlook mail message by using Automation, as follows:

1. Initialize the Outlook session.
   
2. Create a new message.
   
3. Add the recipients (To, CC, and BCC) and resolve their names.
   
4. Set valid properties, such as the Subject, Body, and Importance.
   
5. Add attachments (if any).
   
6. Display/Send the message.

Labels: E-mail, General, Reference, Tips, Tutorials

Don't let Outlook stop you

Outlook 2007-10, 2003, 2002 and Outlook 2000 SP3 allow the user to use a registry key to open up access to blocked attachments. (Always make a backup before editing the registry.) To use this key:

1. Run Regedit, and go to this key:
   
   

   HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook\Security 

   
   (change 10.0 to 9.0 for Outlook 2000 SP3,11.0 for Outlook 2003, 12.0 for Outlook 2007, 13.0 for Outlook 2010)
   
2. Under that key, add a new string value named Level1Remove.
   
   
3. For the value for Level1Remove, enter a semicolon-delimited list of file extensions. For example, entering this:
   
   

   .mdb;.url

   
   would unblock Microsoft Access files and Internet shortcuts. Note that the use of a leading dot was not previously required, however, new security patches may require it. If you are using "mdb;url" format and extensions are blocked, add a dot to each extension.
   Note also that there is not a space between extensions.

 

If you are using this registry entry, a glance at Help>About Microsoft Outlook will show Security Mode: User Controlled above the license information.
After applying this registry fix or using one of the above tools, the user still has to save the attached file to a system drive before opening it. In effect, the fix rolls the attachment behavior back to Outlook 2000 SR-1, with its included Attachment Security Fix.
An end-user cannot bypass this "save to disk" behavior and open the file directly from the mail message, though an Exchange administrator can.

Labels: E-mail, General, Reference, Shortcuts, Tips, Tutorials