Send e-mail - filter date range & customer name

Evening All

With the attached worksheet I am trying to e-mail the customer a weekly acknowledgement e-mail of the submissions they sent last week (Monday-Sunday) and submissions which have been completed.

I have two issues:

- The code e-mails every customer, even if they didn't send or have completed any work last week. I'm guessing I need to alter the below?

Please Login or Register  to view this content.

- Secondly, I cannot get the code to pick up the date range in Column D. If I change the format to number type no problem but in Date format the e-mails all appear blank. Any ideas please?

Please Login or Register  to view this content.

Many thanks!

1st issue: there is nothing (criteria) which reduces the number of emails. A criteria for

even if they didn't send or have completed any work

is missing

2nd issue: if you check the variables in the "Local Window" you see that "ProjectData" is of type Variant/String and you compare therefore a string with a double
change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

cheers

only add two more (the easiest way)

Please Login or Register  to view this content.