This isnt your typical email request, in this case I would like to set a Calendar event for a list of users with a reminder (Series) in OutLook.
Has anyone tried this, is it possible?
Cross posted:
http://www.microsoft.com/office/comm...60b&sloc=en-us
Last edited by Rick_Stanich; 10-30-2008 at 11:18 AM.
Regards
Rick
Win10, Office 365
Hello Rick_Stanich,
Do you want to send a reminder email to each person in the list on a specific day and time (Appointment)? What will the reminder message be? Will this information be taken from a worksheet?
Sincerely,
Leith Ross
Yes Leith, a reminder.
The message would be generated within VBA and would be something like this:
This is an automated message!
You have been issued CAR PRO 001.
Please complete the CAR by 10/23/08.
Values in BOLD will be generated from the macro, I have a userform that collects data where these values can be extracted.
I know how to send an email but not how to send an appointment.
If you are aware of a better method to send a message that can be re-ocurring, please let me know.
Last edited by Rick_Stanich; 10-23-2008 at 09:16 AM.
As it turns out accessing the calendar is daunting and requires access to the public folders if you want to make reminders for other users on your network
But, setting TASKs is much simpler, so to speak.
This code sends an email and sets a TASK for a user. Now all I need to figure out is how to set a reminder timer for the task.
Please Login or Register to view this content.
I cant seem to get the "Reminder" to set?
Its like it is being ignored.Please Login or Register to view this content.
Hello Rick,
I modified a macro I wrote to send out emails at a later time and date. This seems to me what you are doing. If you want to send an email or group of emails at a later time or date, this will do just that.
Sincerely,Please Login or Register to view this content.
Leith Ross
Leith, what an exceptional idea and I'm going to try to use it instead.
As for the Task setting for the Reminder.
When sending the task you can set the Reminder as I did in the code, but it will not do you any good. Once the receiver accepts the Task the Reminder is set to false.
Why? Ask MS.
Leith, I am getting an error in this modified code, can you lend a hand...again
Strangley that same line works fine in this code as a stand alone module:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Rick_Stanich; 10-29-2008 at 11:13 AM.
Hello Rick,
Can you tell me which line generates the error and the error code?
Sincerely,
Leith Ross
Yes (It is also highlited the same in my post)
In the first set of code I posted, it fails, in the second set of code I posted it works?Please Login or Register to view this content.
Hello Rick,
When using late binding (creating the object at run time) the object library constants aren't available. You can either replace olMailItem with a 0 (zero) or declare it like this...
Sincerely,Please Login or Register to view this content.
Leith Ross
Thank you Leith, it is very much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks