Display Fridays date (and message) if current date is Monday

**Pierce Quality** · 09-25-2013, 09:20 AM

Hi All,
I currently have the VB code set to display yesterdays date in an emails subject line, but I need it to display the previous Fridays date instead if the current date is Monday. Additionally, I need the second line in the email body to only display if those same conditions are true. We email reports from the previous work day's data, but on monday we also have the same report to email with additional data. Automating this process will save us quite a bit of work. Thanks!

Please Login or Register  to view this content.

The original full code was graciously provided by John H Davis here:
http://www.excelforum.com/excel-prog...tus-notes.html

Thanks again!

**Pierce Quality** · 09-25-2013, 10:28 AM

Bumping along.

**Pierce Quality** · 09-25-2013, 11:53 AM

Bumping along.

**slx** · 09-25-2013, 12:31 PM

replace your subject line with this

Please Login or Register  to view this content.

**Pierce Quality** · 09-26-2013, 09:40 AM

Originally Posted by slx

replace your subject line with this

Please Login or Register  to view this content.

Thank you very much, that worked great for our subject line! Under that structure we were able to get our addional text to display properly in the body as well.
Here is the current code:

Please Login or Register  to view this content.

We are still having an issue with our signature not getting displayed, but I will be posting that under a different thread today and marking this one as solved.
Thanks again!

Display Fridays date (and message) if current date is Monday

LinkBack

Thread Tools

Rate This Thread

Display

Display Fridays date (and message) if current date is Monday

Re: Display Fridays date (and message) if current date is Monday

Re: Display Fridays date (and message) if current date is Monday

Re: Display Fridays date (and message) if current date is Monday

Re: Display Fridays date (and message) if current date is Monday

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to fill in date values of current week beginning with Monday using button.

if date col is monday sum current and 6 previous daily amounts to determine weekly amount

Date Picker Control will not display Current Date

SOLVED - Display the date of the previous Monday?

Re-open. Formula to generate current weeks Fridays date plus conditional formating

Bookmarks

Bookmarks

Posting Permissions