Sent from Access

A recent issue has information about sending reminders to Outlook from Access.

"If you have a table that contains a date field, and you want to make sure that something happens on that date, one way is to create an Outlook task with a reminder that will pop up on the specified date; you can even use the Outlook reminder to create an email message that will be sent on the specified date.

This article will show how to create an Outlook task from Access VBA code, and send an email message when the task's reminder fires."

The file is located on Helen Feddema's site.
Access Archon
Scroll down to #126

The zip file contains the WAW article, in Word format, plus the supporting file.

Helen Feddema has been working with Word since v. 1.1, Access since the beta of v. 1.0, and Outlook since the beta of v. 8.0 (that's where Outlook started its version numbering).

Labels: Access, Appointments, VBA

HEADING

More than name tags

Here are a few of the 31 suggestions:

• Turn a message into a meeting request
  
• Update a meeting request
  
• Automatically process requests and responses
  
• Counter-proposals for Meeting Times
  
• Cancel meeting if you are an attendee
  
• Troubleshoot meetings

One of the subjects is:
Outlook meeting requests:
Essential do's and don'ts

Here are a few of the items:

If you change it, update it:

After modifying one of your own meeting requests, remember to click Send Update to send the updated request to all recipients.

Don't move meeting requests:

Don't move a meeting request from your Inbox to a different folder before you accept or decline the request or before the meeting appears in your calendar.

Soon after a meeting request arrives in your Inbox, a piece of Outlook code -- nicknamed the "sniffer" -- automatically adds the meeting to your calendar and marks it as tentative. This is a fail-safe to keep you from missing the meeting in case you don't see the request in your Inbox. However, the sniffer doesn't reply to the meeting organizer. You still need to do that by accepting, accepting as tentative, or declining the request.

If you or a rule that you create moves an incoming meeting request from your Inbox before the sniffer can process the request, the meeting never appears in your calendar, and you might miss the meeting.

Get a fresh start:

If a meeting series requires several changes -- a new organizer, a different frequency or time slot, the addition or removal of attendees -- just cancel the series and create a new one. Don't try to modify the original meeting request.

Also:

Slipstick.com:
Scheduling Resources

Meeting Name tags



See all Topics

outlook

Labels: Appointments, Calendar

Red letter day

1. Simply right click on the event
   
2. Select Label
   
3. From here you can select from a variety of pre-selected colors

Appointments can also be Automatically formatted.

1. Right-click a meeting entry and choose Automatic Formatting...
   
2. Click on Add and name the Rule.
   
3. Next, click Condition and set up a Filter such as having the word "Dr" in the subject or note field.

"… if you have ten or fewer main categories that you use on a regular basis, you might want your label names to be the same as your categories. To change the default label names, go to the Edit menu from the Calendar view and click on the Labels option."

Labels: Appointments, Calendar