Hello all!
I have some working code but I need one more thing added to it and I am stumped.
Goal:
I have a Customer Shipping Tracking Log (excel 07) and I need it to automatically email (outlook) tracking information to customers at the end of the day. I need it to only send emails for orders that have ship dates that are today's date.
Plan:
Before application close, message box "do you want to send out tracking information from today's date?" if yes, run the code and send out emails to the customers who have emails stored in the Mailinfo tab.
What I have:
The code works perfectly, but it takes all the data for each customer from the active worksheet. I need it to only email rows with today's date.
Can anyone help? Thank you.
Bookmarks