MSubject = rText.Offset(x - 1).Value & " on " & rDateValue Set rText = Application.InputBox("Select Email Topic Range:", "Exceldemy",, ,, ,, 8) Set rSend = Application.InputBox("Select Email Range:", "Exceldemy",, ,, ,, 8) Set rDate = Application.InputBox("Select Deadline Range:", "Exceldemy",, ,, ,, 8) We’ll send an email to that person using the VBA code.ĭim lineBreak, pBody, rSendValue, mSubject As String Hence, there is only one row that falls within seven days. Send Email in Excel Based on Date Conditionsįor the last method, we’ll send emails if the deadline is within one week period of the current date. Read More: Automatically Send Emails from Excel Based on Cell Contentģ. Two people met our condition, hence we’ll see two emails window here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |