How To Automatically Send Customized Birthday Emails With Microsoft Excel

In this week’s training, I will show you how to automatically Send Customized Birthday Emails.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 - Introduction
0:34 - Overview
10:18 - Create Send
55:53 - Open Workbook

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #birthdayemails #sendemailsinexcel #automatebirthdayemails

[kstone]

Thanks for this video. It would help me more if you could walk through the design process of the excel workbooks because I really need that type of training. I really like the quality of your work.
I also like how you use real life examples in the design of these workbooks. On the Customer sheet it would have been nice to have a Userform to add and edit the Customer table. Because you only have 19 rows for the customers data formatted.

[Mitrashankar]

Hello..thanks a lot for this video. instead of the attachment is there a way to attach the card in the body?

[SyedMuzammilMahasanShahi]

I just watched this video. Thanks for the share.

[Serg..hz]

Thank you very much for your excellent work. Each video gives an incredible experience. I did everything step by step, but I can not understand why VBA shows an error in the code
(Expected Sub, Function, or Property
in line LastRow

.

[tobayekaina]

Hi Randy. This is a great video. Thank you. Looking for how to :
1. send each concerned line to 2 different e-mail addresses
2. Start the workbook and send e-mails automaticaly

[sachinshinde]

Very helpful sir...
Please make video for sending birthday emails for employees via Gmail account....
Thank you....

[samrajkumar]

Awesome, I have prob only in sat and Sun b days

[linadeli]

Hi Randy thank you so much it's actually the date format that was the issue. I have another question if its ok. If I have to send an automated payment reminder email to all customer, is there a way to delay the next reminder for a week later If that particular customer who had still not payed yet, had already received the reminder beforehand?

[DaneHigbee]

Is there a way to do this if I have multiple sheets with names? Like, I have departments broken down into sheets 1-9. How would I do this same thing for each sheet? Would I need to copy the code and change the sheet name but have a new Module?

[kstone]

Hi Randy, I worked on this video today and when i went to run the macro everything worked except the chart came out blank. When i stepped one line at a time everything worked fine.. Is there away to slow down the loops? Because it seems to work fine when its one line at a time. Thanks

[mohamedsamir]

Could you support me with a link of downloading the excel file containing the template image, as when I run my script the attached file is empty

[Muralidharsastry]

I am getting error in the start of the code. after with Sheet2 and starting with LastRow, it is showing error Says Expceted Sub, Function or Property. please suggest

[linadeli]

Hi there, I tested the excel file I notice that if the date is the same number as the month for example 11/11/2018, the excel will still send the email is there a way to fix this?

[ashwinramesh]

Hello Randy,
I tried to run the script I am seeing the compilation error in LastRow Line and below is the line as follows
LastRow Please help me with this issue
Error Details: Expected Sub, Function, or Property

[siddhkishan]

How can I add bday wish picture on mail body instead of attachment

[rupeshrane]

Hi Sir,
Download Link is not working.

[nagdy]

Dear, I try that file "Automated Birthday Emails" But doesn't work with me.

[ankitrsingh]

The email attachment i am getting is blank.. pls help

[rkexcel]

sir excel file se sms send kar sakte hain free me plz tell me now

[yacinedz]

Good day, Can the copon send to whatsapp please. that would be much better