Sending Emails to outlook via Excel with 2 tables

Hello,

I have a complicated requirement!
I have a list of more than 300 participants to whom I have to assign different depts. (Sheet-Email, Range N to S) for their orientation.

We have to send emails to each and every participants along with their assigned depts. table., and also table 2 given in Sheet-Dept Details., where the Dept's contact details, timings, POC etc. are mentioned.

In column E (Email Body), I have explained the way how my email draft should look like. For each participant it will be different. (Because of the tables)
Can someone help to create a user form with all these requirements?

Also when clicked on send button, I want it to directly send emails and not wait for me to again click on send button in outlook.

I have always got solutions here, I hope this gets solved too!

Each email begins with "Hello Miss,". Is it always "Miss" or could it be "Mr." or something else? If the body of the email is always going to be the same for everyone with the exception of "Miss", then you actually need only the "Miss" or "Mr." in column E. Please clarify.

Hi,

It will names of the attendees, I just wrote that in all as a sample.,

Apart from the name and the 2 tables, the message will be same for all
Also... In my image that I have attached, I have given only depts by day... I will also add the columns of unique id ,their names and contact details...i.e from Column H to S

Have a look at the attached file. Please take note of the directions in cell F1. When you double click on any cell in columns F or G, a window will pop up where you can find and select a file you want to attach to the email. This must be done before you click the "SEND" button. Also, change "Display" to "Send" in the macro in Module1 to suit your needs.

Hi Mumps...

It is perfect!... only as mentioned in my post#4, I also want the first table to be from range I instead of N...

I tried to change the code (highlighted in pink), but it is showing me error in below line..... not sure where I went wrong. Can you help to rectify?
.Subject = v(i, 10) & " " & v(i, 12) & " | Dept. Visit"

Please Login or Register  to view this content.

I am attaching another image with the output that I want. Added columns with Yellow color heading

Try the attached file.

You are very welcome.