Good morning all,
VBA Novice here!
I'm making a userform that returns an email using the "With Outmail" with statement to send .HTMLbody code as a message. In the first line of the subject, I want to inform the submitter that we will respond to their request by close of business on the 2nd business day from the submission date. However, the current "code" I used doesn't account properly for business days.
Can anyone help me modify the code so that it accounts for business days? This is part of the Click event procedure for a "Submit" button where "tbTodaysDate" is a locked text box field that auto-populates today's date..
Dim LDate As Date LDate = DateAdd("d", 2, EscalationsForm.tbTodaysDate.Value) 'More Coding for the outlook email 'Picks up here With OutMail .HTMLbody = "We will respond to this Escalation by close of business on " & Format(LDate, "Long Date") & "."
Any help is greatly appreciated as I've seen some answers using functions but I don't know how to properly deploy them, nor do I understand what they are doing.