Auto Email Sent from Excel on a particular date without opening Excel

Hello All,

I hope everyone is all right & doing well in this pandemic.

I am into making some reminder file for something. Attaching sample file herewith. All i need to do is to send a mail having all data mentioned in respected column with heading and track sent reminder date in the same file.

Need help to write macro which will perform this job without opening excel.

Is it possible to have a macro which will also not open the outlook and send the mail?

Thanks

Originally Posted by Darshan Shah

Need help to write macro which will perform this job without opening excel.

It is not possible for an Excel macro to run if Excel is not open.

Thanks for your code maniacb!

Found some error. Attaching herewith the screen shot.

The workbook module should be

Please Login or Register  to view this content.

Yes Working Fine

Can we add our default signature as well?

Thanks again.

Originally Posted by Darshan Shah

Yes Working Fine

Can we add our default signature as well?

Thanks again.

I tried Signature as a string but VBA is only copying the text from default signature. Logo and font style is different. Any possible way?

Update the main module to this code to include the default signature

Please Login or Register  to view this content.

It's working like a gem. Default signature is attached well! Thanks for the code
But when using HTMLBody, text are align and font style got changed to Times New Roman. I used "vbNewLine" as i have multiple lines in body. But using HTMLBody, text are getting aligned. Any other way out to solve this?

Further, Can we make some text as Bold or font size can be increase?

For Example, in body i want my description as below:

Dear Sir,

We have sent material on 24-01-2021 for Job work.

Please update status of delivery. It should be deliver before 30-01-2021 (The font size of this date should be large).

You can use the code as follows, but the borders of the cell also show up in the email.

Please Login or Register  to view this content.

Yeah you are right! Not looking good

That's the only way?

And can we do that bold thing & font size thing in mail body?

Update the function to the following code. It will capture any formatting in the cell.

Please Login or Register  to view this content.

Updated with this code but not getting bold font in mail body. Did i missed something?

Did you bold the txt in the cell before running the code?

Yes. I Did.

Try it from this workbook. The bold comes through.

Yes. Its working. Thank you.

Hey maiacb!!

Came back with just one more query regarding the same file. Can we add macro button to trigger the code?

Send Email Button has been added

Thanks again Its working!

If that takes care of your original question, please select*Thread Tools*from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.