Bulk Email and Individual email from Excel File to Outlook

[vikas_newports]

Hello

I hope everyone is doing well .... I am trying to send bulk email from excel sheet to Outlook but I am getting formatting issues in body and also some addition fields are not added in body
My excel macro file is attached. Also a doc file attached for email body format. this format is fixed for all recipients just ID and Score changed in body.

Here are some excel file details
ID available in Column C
Score% Column BQ
Suggestions in Column BR

my Macro code is as below

Please Login or Register  to view this content.

[Logit]

.
See of this works for you ...

Please Login or Register  to view this content.

[dangelor]

Added the template to a worksheet...

Please Login or Register  to view this content.

[vikas_newports]

[QUOTE=dangelor;5472175]Added the template to a worksheet...[CODE]Sub Send_Mails()

Some formatting issue found. image aatached .

[dangelor]

Try this version of code and template...

Please Login or Register  to view this content.

[vikas_newports]

Try this version of code and template...[CODE]Option Explicit

Sorry for the late response but due to some covid issue i was stuck somewhere, as it is working fine for sending emails to all mentioned recipients in the sheet ....
but What if I want to only send to selected recipients or a single recipient ... like placement of a button to every single record to send email . or select from a list to send email to select recipetns .

[dangelor]

I would set up a range that has a list of email addresses, i.e.,Sheet1.Range("A1:A10") and use this for the TO string.

Please Login or Register  to view this content.

It will ignore blank cells in the range.

[vikas_newports]

I would set up a range that has a list of email addresses, i.e.,Sheet1.Range("A1:A10") and use this for the TO string.

Please Login or Register  to view this content.

It will ignore blank cells in the range.

where should I place this code in above mentioned code
replace this line to suggested code

Please Login or Register  to view this content.

[dangelor]

After you create the range, yes.

[vikas_newports]

I tried it but not working might be I am writing wrong range for it . can you please adjust it

[dangelor]

What's the name of the worksheet and the range address that holds your email addresses?

[vikas_newports]

What's the name of the worksheet and the range address that holds your email addresses?

I am using the file from post # 5 and sheet is Send_Mails

[dangelor]

I think I'm misunderstanding what it is you're trying to accomplish.

The code in #5, sends emails to every address in the list on the Send_Mails worksheet. How do you populate that list?

[vikas_newports]

Actually, I want to send multiple emails at once and now I am thinking to send email to only select persons. like I want to send email to only john then I go to john address and click on send email button.

I am inserting manually email address and my main email data is available in QA Consolidated sheet
Column C , BQ and BR are the main columns for email template.

I think I'm misunderstanding what it is you're trying to accomplish.

The code in #5, sends emails to every address in the list on the Send_Mails worksheet. How do you populate that list?

[dangelor]

To email select people you would, at the least, need to include email addresses to the database and devise a simple way to differentiate those people in the list.