VBA Code To Send Automatic Mail Reminder For Meeting X Days In Advance

Here's the updated file with code.

Excel Fox, everything works great! I need something else added to the email, per my supervisor. The date of birth, column D, and the transport, column G. Could you do it where if the transport column is empty then it doesn't need to be in the email. If there is something in there, then it needs to be in the email. Thanks!

Sure. Can you share the exact format of the mail for both cases

Sure.

Dear John Doe:

You have an appointment scheduled. Please find details below:

Client: William Harrison. DOB: 04/04/08
Time and date of appointment: 13 December 2014, 9:00 AM. Venue: 5678 President Circle, Seattle, WA 12345
Note: Please Transport

And if column G doesn't have anything in it:

Dear John Doe:

You have an appointment scheduled. Please find details below:

Client: William Harrison. DOB: 04/04/08
Time and date of appointment: 13 December 2014, 9:00 AM. Venue: 5678 President Circle, Seattle, WA 12345
Note:

Excel Fox? Any chance you had a chance to work on it?

Hi Excel Fox,
if u will allow then i want to Post your file with this little part to complete the requirements.

I have done this and file is ready with me.

Thanks//

Dinesh, why don't you post it here. If its in line with what exceldumby wanted, great. If not, I will finish it after exceldumby's revert

Attachment 1712

Thanks Excel fox,

Hi exceldumby,
please find attached file check and let us know if anything missing.

Hi DInesh,

That macro is perfect! Everything looks great. I have another question, can I use this macro in a shared worksheet? I've tried to run the macro in a shared workbook but it doesn't do anything.

Hi,
i have not tested it for that. i will try in free time. can u share error description and screenshots?