Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outlook Reminder Automation 1

Status
Not open for further replies.

handlebars

Technical User
Feb 18, 2003
270
GB
Is it possible to have the contents of an outlook reminder put into an email that can be emailed to a distribution list?

I understand that you can access the reminder objects by index numbers, but is it possible to have the reminder itself trigger the function that sends the email?

Thanks in advance

Andrew
 
Andrew,

How many reminders that will fire off an email will you have? And will they fire off separate emails or the just one standard one.



Matt
[rockband]
 
Matt

It would be a standard email, produced when the time of the OriginalReminder time is equal to the current time (both formatted as hh:mm).

What I am not sure how to do is get the procedure to "fire" when any reminders appear. ie i can get a sub to work if i run the code, but what can i do to get the code to lay there until an reminder appears??

Any advice would be truely appreciated.

Andrew
 
Andrew,

In the visual basic editor for outlook you will need to select application from the dropdown box. ("This is defaultly set to general.") Then select the next dropdown box and choose reminder.

Then all you need to do is call the macro that will send the email for you. Note that this will be called for all reminders that are set.

You should have something like this.

Private Sub Application_Reminder(ByVal Item As Object)
Call yourprogramname
End Sub


HTH



Matt
[rockband]
 
I have managed to get it to run perfectly apart from the message box that Outlook brings up to ask you if you want to send a message that has been created outside of Outlook.

Would it be possible to set the activealerts property to off via vba code?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top