Use Excel VBA to create an e-mail w reminder

Solved/Closed
BrunoD - Feb 23, 2011 at 03:53 AM
 Bruno - Mar 2, 2011 at 03:47 AM
Hello,

I create a file in Excel that does some calculations based on a small database and some user input. I then added a button to open an e-mail (Outlook) containing the results.

That works perfectly with following parameters:

Set Source = range("email!A1:B19")
Source.CopyPicture xlScreen, xlPicture
On Error Resume Next
With OutMail
.To = ToMsg
.CC = CopyMsg
.BCC = BccMsg
.Subject = "PO " & orderno & " - Kuehne+Nagel - Belspeed Approval"
.HTMLBody = RangetoHTML(Source)
.BodyFormat = olFormatHTM
.Display
End With

The only thing missing is a follow-up function: the recipient of the mail should be made aware via a follow-up or reminder that a reply or action is required within 3 days. Are there any options I can add to this purpose?

Thanks for your help
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 27, 2011 at 05:03 PM
see this thread. I have not tired it. Hopefully it will work for you. either way it would be nice to have a feedback on your finding

https://www.excelforum.com/excel-programming-vba-macros/695307-add-reminder-flag-to-email-item-via-excel-vba.html
0
Hi, I found another solution. It doesn't set a real reminder but changes to mail to red when the due date has passed. Here is the code I entered jus below the .Bcc part.

.FlagStatus = olFlagMarked
.FlagIcon = 3
.flagdueby = FollowUpDate

Thanks for checking :-)
0