• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Send mail with reminder - How to set the next calendar working day problem

Villalobos

Active Member
Hello,

I use the below mentioned part of code to send mail with reminder but my problem is that regarding the reminder: How to set the next calendar working day?

Could you please give some advice how should I set this?

Code:
  With OutMail
  .To = ""
  .CC = ""
  .BCC = ""
  .Subject = "" & Format(Date, "dd mmm yyyy")
  .body = ""
  .Attachments.Add Destwb.FullName
  .Importance = olImportanceHigh
  .FlagStatus = olFlagMarked
  .FlagRequest = ""
  .FlagDueBy = Date + 1 & " 10:00 AM" '<- How to set the next calendar working day?
  .Display
  End With

Thank you in advance your help!
 
Back
Top