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
.To = ToMsg
.CC = CopyMsg
.BCC = BccMsg
.Subject = "PO " & orderno & " - Kuehne+Nagel - Belspeed Approval"
.HTMLBody = RangetoHTML(Source)
.BodyFormat = olFormatHTM
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?