EMAIL VBA and DUE in 30 DAYS

  • Thread starter Thread starter Marilyn
  • Start date Start date
M

Marilyn

Hi I've been using Ron DeBruin VBA code to send the same e mail to different
people.
I need TO ADD a line to say "The above agreement is due (30 business days
from today, including any holidays) Example: If I send out the message today,
5-12-08 it will be due 6-23-08 or 30 business days later.

Msg = "The above agreement is due ?????????????" Thank you in advance
 
Use something like this

MsgBox "The above agreement is due " & Format(Application.WorksheetFunction.WorkDay(Date, 30), "mm-dd-yy")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating interest due on late loan payments 1
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
End Date Calculation (adding a start date duration) 5
Sumproduct with added days 2
30, 60, 90 days late and due within 14 days 1
SUM if date < 30 days away 6
Pop Up Calendar 1
Rounding time of day up to fall in during work hours 8

Back
Top