Data Validation Paired with VBA Email Macro

Hi,

I've got an email macro that generates an email to a particular company from a dropdown selection. When an Email is sent, another macro button is clicked to record the date in a " Date Sent" column on another sheet for that particular company. I'm wondering if i can attach a data validation to the to Email macro that would generate a popup alert to the user when they attempt to send an email to a company if that company already has a date stamp recorded in the "Date Sent" in its respective row. Thanks in advance! Here's the email code:

Please Login or Register  to view this content.

And this is the Date Stamp Code:

Please Login or Register  to view this content.

Here's the related worksheets. The "email Sheet" will be populated with the company name and email credentials, and the "Current Clients" sheet is where I record the date stamp with the two buttons on the right in the "Email Sheet". Let me know if this helps. Line Ticklers by responsibility excel.xlsm

I only want a "Date Recieved" message to be included only when there is actually a date value in the recieved column. If the recieved column is blank, then I don't want that particular "Date Recieved" line inlcuded in the message. How would this be done? This is what the code looks like currently:

Please Login or Register  to view this content.

Great, thanks!