Learn Excel- Video 56- VBA -How to send Emails automatically

How to Send E-mails automatically using VBA.

[krishacharya]

This is great video you have uploaded. Thanks.

[rakeshkumarmadella]

Wow wow wow.. You are putting so much of energy.. It's amazing I can't believe it sir ji.. Thank u so much... Can we send emails, to different people, with an new attachment in every new email ID.. Suppose I want to send 20 emails to different mail address with their own attachments... Once again u r the best.... Bingo....

[Globalpeaceseeker]

hi when you enter .to and .cc if instead of typing who you want to send the email to in the actual spreadsheet rather than in vba what would be the code? would you for example write .to range "a1" if a1 contained the recipient name?

[Nilanee]

Hi Ajay, Thanks for making this. I have some questions on this
How can I add todays date in Sub, how can I add folder path in Body, and signature (my out look standard format)

[deepakeugene]

Can we develop a macro for mail merge? If yes, could you please help me?

[T_h_e_Best]

Hi Ajay. Video of auto sending mail is cool but additionally will be better if I'll have possibilities to send some kind of mail on exact day of each month & in exact day and time which I set up...for exp: macro will run in 15.08.2018 on 14.35 pm. But counter have to start make count time from today:24.06.2018...could you show haw do that?

[levelupexcelskill]

Could you please make a video automatic download and consolidate with specific range

[deepakeugene]

How do I add multiple email addresses under "TO" using the excel by selecting the range of the email address?

[ankitgarg]

Sir, Plz tell me how to paste Excel range into outlook body ASAP?

[AmitdFatfit]

Hi Sir.

I have different excel files in a folder.

How do we send separate auto emails attaching each of these files from this folder and each file needs to be sent to different email id.?

There is a separate excel file which has a list of names and their email id's

The ".to" will pick up email id from this email list and will pick up the email id as per the name of the workbook.

For ex:-


Then the first email should be sent to the above email id and similarly loop and then send another email for different workbook name whose email contact in the email.list is different.

[hopethedream]

How to get signature automatically populated.