How To Automatically Send Customized Birthday Emails With Microsoft Excel

[@ExcelForFreelancers]

📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

[@Mitrashankar]

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

[@ExcelForFreelancers]

Hi and thanks so much. You can attach it using HTML. I show you how to do this in this video: kzbin.info/www/bejne/hZywYmuKeZaZeqs Thank you for your Likes, Shares & Comments. It really helps.

[@Mitrashankar]

@@ExcelForFreelancers thank you :)

[@SyedMuzammilMahasanShahi]

I just watched this video. Thanks for the share.

[@ExcelForFreelancers]

For sure, you are very welcome Syed. This video is very old. Glad you enjoyed it.

[@SyedMuzammilMahasanShahi]

@@ExcelForFreelancers pleasure

[@k102stone]

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.

[@ExcelForFreelancers]

HI thanks so much. I realized that people like to watch me design, so my last two videos (Contact Manager, and Inventory Manager) I started with blank workbooks. So please have a look at the last two. For the sample workbooks, hopefully i can give you training to customize these workbooks and expand the applications to fit your needs. Thanks so much for the valuable feedback.

[@Serg.105.1hz]

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 Sheet1.Range("E9999").End(xlUp).Row .

[@ExcelForFreelancers]

Hi this should be: LastRow = Sheet1.Range("E9999").End(xlUp).Row I hope this helps and thanks. Thank you for your Likes, Shares & Comments. It really helps Sergei

[@tobayekaina8610]

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

[@ExcelForFreelancers]

Hi thanks for your message. Our group members would be happy to help you with that. If you can join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel and post all the code you have tried, with your issues, they will be able to guide you (more than I can in a KZbin comment) Thanks so much.

[@sachinshinde5997]

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

[@ExcelForFreelancers]

Hi Sachin thanks so much. I do have a video on how to send emails with your Gmail account right here: kzbin.info/www/bejne/jaCmpoV8etp0eck Thank you for your Likes, Shares & Comments. It really helps.

[@osamasaid8476]

USEFUL

[@ExcelForFreelancers]

Glad to hear that Osama and thanks so much

[@samrajkumar2868]

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

[@ExcelForFreelancers]

Hi and thanks for your comment. Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.

[@linadeli7885]

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?

[@ExcelForFreelancers]

HI Nor, thanks for your comment and glad you were able to get the date issue worked out. You can save the last reminder date for each customer in a specific column for a customer, then you can run and advanced filter and test if this specific date is less than or greater than the current date. If greater you can then send the email and update the date. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@mdsaiful6294]

Nice video 😌😌

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Saiful

[@mumbaitiger]

Excellent

[@ExcelForFreelancers]

Thanks so much Neville. Thank you for your Likes, Shares & Comments. It really helps.

[@k102stone]

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

[@ExcelForFreelancers]

Hi yes that makes sense to slow things down. Its always a good idea. you can slow it down a bit by adding Application.Wait Now + 0.00001 Adjust the numbers to speed up/slow down the code I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@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?

[@ExcelForFreelancers]

Hi and thanks very much. It may be easier to either manually or with VBA, have all of the names on a single sheet. Then you can loop through the names. If you need help with this feel free to email me and I can refer a qualified developer [e-mail] I hope this helps and thanks so much.

[@mohamedsamir5538]

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

[@ExcelForFreelancers]

Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

[@mohamedsamir5538]

@@ExcelForFreelancers yes I've downloaded it but found that the template sheet doesn't have the attached image and when I inserted an image and then run the script the email is sent but with a blank attachment, there may be a missing part or something that I should do to upload my attached image with the email, Please advise!

[@ExcelForFreelancers]

Hi Samir,. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@linadeli7885]

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?

[@ExcelForFreelancers]

Hi Nor you will want to make sure all date formats (computer, Excel, Cells and VBA are the same to avoid conflicts) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@nagdy83]

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

[@ExcelForFreelancers]

Hi thanks if that is not working you can use a picture as a range as demonstrated in this video: kzbin.info/www/bejne/hZywYmuKeZaZeqs

[@Xenogenisis69]

@@ExcelForFreelancers I have sent a request for the birthdayemail download a couple of times but I have not gotten anything in my email, can you please send me the download.

[@ExcelForFreelancers]

Hi i am very sorry for that, sometimes it may go to spam. You can download it from the following link: bit.ly/AutoEmailWkDl

[@Xenogenisis69]

@@ExcelForFreelancers I figured something like that, and I got it now. Thank you!!

[@nagdy83]

@@ExcelForFreelancers Thanks alot, Picture range it's gonna be working well with me. But how i can use it through SMTP not though outlook. Thanks,

[@ashwinramesh2721]

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 Sheet1.Range("E9999").End(xlUp).Row. Please help me with this issue Error Details: Expected Sub, Function, or Property

[@ExcelForFreelancers]

Hi and thanks for your comment. Please change the code to: LastRow = Sheet1.Range("E9999").End(xlUp).Row I hope this helps and thanks so much.

[@ashwinramesh2721]

@@ExcelForFreelancers Instead of adding as an attachment can we paste the image in Email itself, If Yes please let me know the code so that I can try myself.

[@ExcelForFreelancers]

HI and use you can use HTML to place the image. I teach you how to do that in this video: kzbin.info/www/bejne/hZywYmuKeZaZeqs

[@ashwinramesh2721]

@@ExcelForFreelancers I have another doubt, I dont want this working days, current weekday and next working day logic and instead I want to send birthday emails if the bday date is equals to todays date. Is there any other way? If yes, can you please let me know how to do that...

[@ExcelForFreelancers]

HI and thanks yes certainly that can be done, based on a formula, however i could not know this formula based on your comment. Please post your workbook and formula in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@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

[@ExcelForFreelancers]

Hi and thanks make sure your macro Starts with Sub and ends with End Sub. Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@rupeshrane8252]

Hi Sir, Download Link is not working.

[@ExcelForFreelancers]

Hi If you have tried to download this workbook using the links but had a problem please email [e-mail] . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

[@siddhkishan]

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

[@ExcelForFreelancers]

Hi thanks so much for your question. I have this training video on my list of videos to create as far as adding a picture as an html body coming up for training, however if you require that new you can search "Send Email With Excel using HTML body" that should help for now. Thanks very much for your support.

[@siddhkishan]

Excel For Freelancers thanks for quick response, my suggestion is if this picture will be on mail body instead of attachment that will show more attractive mail

[@ExcelForFreelancers]

HI this Tuesday 6-19-2018 I am releasing a video on HTML to show pictures and tables an email body. I just wanted to let you know. I think you will love it.

[@ExcelForFreelancers]

Hi you can add pictures inside the email shown here in this new training video: kzbin.info/www/bejne/hZywYmuKeZaZeqs

[@ankitrsingh]

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

[@ExcelForFreelancers]

Hi thanks if this is not working for you, you can also try an HTML email here: kzbin.info/www/bejne/hZywYmuKeZaZeqs I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@rkexcel2686]

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

[@ExcelForFreelancers]

Hi thanks i do not have any Excel to sms as that would require a 3rd party, paid add-on.

[@yacinedz4149]

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

[@ExcelForFreelancers]

Hi and thanks very much. Whatsapp requires a Business API Account to send via Whatsapp. I hope this helps and thanks so much.

[@ExcelForFreelancers]

Hello! I am very happy to share the news that I have created this training for you and it will be premiered this Tuesday September 12th. Please make sure to Like & Share it here: kzbin.info/www/bejne/iZS4c4acetaWqLs