mail automation support

Fortunately I have a "plug and play" macro for mailing using outlook. Here are the arguments that can be passed to it:
' ToString = List of addressees in To field, semicolon delimited
' SubjectString = Subject of the mail Message
' BodyString = Body of the mail message
' ReplyTo = (Optional) Reply to email address
' OnBehalfOf = (Optional) Mail on behalf of (must have permissions)
' CCString = (Optional) List of addressees in CC field, semicolon delimeted
' BCCString = (Optional) List of addresses in BCC filed, semicolon delimited
' AttachmentName = (Optional) List of full-path name attachments, semicolon delimited
' SendDisplay = (Optional) True = Send mail automatically, False = display only as draft

I changed the mail Id range to a table. There are too many good reasons NOT to use Excel Tables.

The Control Panel is used for scratch calculations and to set the Mail Flag (SendDisplay). I set it to False for the purposes of testing. With false, the mail is displayed and not sent automatically. You will need to press send to send t he mail. When set to true, mail is sent automatically without human intervention.

Here is the version that corrects that issue.

Before I go further, do you want the information on rows 11-12 as an attachment or in the body of the text?

This should do it. I made the assumption that you wanted the summary sheet as an attachment.

I made some changes. Mail ID Base is a table, therefore, there is no need to add blank lines. As you add lines to it, the table will grow to accommodate the new lines.

The code looks down the first column of this table, S.no. and it sets the value it finds on the control panel in cell B11. This value is used in the VLOOKUP against the table. For example, to find Mail To: =IFERROR(VLOOKUP(Working_ID,Table_Addresses,2,FALSE),"").

This version of the spreadsheet has some new "innards." I needed to add some code to show both the body of the email text and also be able to include an HTML representation of a range.

If you want to show just the two lines in the body of the email instead of as an attachment, I can do that rather easily now.

Super it's working. You are super cool thanks. one concern is when I change the Mail flag to True.
mails are not going automatically, for each mail I need to click send, earlier it goes automatically why it get changed?
can it get automated.

My bad. I forgot to include the flag while calling the mail program. This version should do it.