I recently created a spreadsheet that will notify me of upcoming offsite meetings by two weeks.
Here is a partial code
With OutLookMailItem
.to = MailDest1
.bcc = MailDest2
.Subject = Range("a1").Value
.Body = Range("B1").Value
I like the subject line to include the following: A Gentle Reminder: Boston (which ever location is within that 2 week notice.)
<colgroup><col></colgroup><tbody>
</tbody>
Here is a partial code
With OutLookMailItem
.to = MailDest1
.bcc = MailDest2
.Subject = Range("a1").Value
.Body = Range("B1").Value
I like the subject line to include the following: A Gentle Reminder: Boston (which ever location is within that 2 week notice.)
<tbody> </tbody> | ||||||||||||
<colgroup><col></colgroup><tbody>
</tbody>