Here's the updated file with code.
Here's the updated file with code.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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//
Last edited by DInesh Mudgal; 12-16-2014 at 12:38 PM.
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
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Using VBA To Send Automatic Meeting Reminder Mailers 1 Day In Advance_Modified.xlsm
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?
Posting Permissions
Reply With Quote
Bookmarks