Help with sending emails via vbs and excel

[demoman0602]

I am wondering if i have even chose the right path to make this work, I have been reading and watching different videos but am stuck. Daily I have to send emails which there are 8-10 different templates in which I am constantly just copying and pasting the following into outlook and sending them from a shared email address that we use:
1. 8-10 different email bodies in which the only changing variables are the Name and the Request Date
2. Email Address
3. Email Subject

Here are some snaps of what I have done so far to give an idea of where i am at

Attachment 458433
Attachment 458434

Screen 1 is just the GUI where in theory

1 enter name
2 enter the email address
3 enter the date they requested access
4 select the message they should get about there status PQ1,PQ2,PQ3 etc
5 click generate to populate the Body of the email with the Variables (Name and Request Date) in the list box to do a final once over
6 send

screen 2 is to show how i have come to map everything out I set up each sheet like an email with each sheet by naming it the applicable status for the sheet name and housing the email body text that i want to use in cell B6.

What I am stuck on is the input of the data and sending the variables that i enter in the gui to cell B6 on the applicable sheet in the proper place and then getting it to populate so I can send it. wondering i there is any good reference points or material for this type of formula if even such exist

Capture.PNG
Capture2.PNG

[gmr4evr1]

Unfortunately, your attachments didn't go through, and a lot of us are unable to see images on here. Is it possible to attach workbook with what you have and what you want with the code you are using?

[demoman0602]

sure this is my code so far

Please Login or Register  to view this content.

i have setup the selection boxes so far but need to match up my input boxes

[gmr4evr1]

Thank you for posting the code. Two things though:
1) If you could, please click Edit Post on your original post then highlight your code and then click the # button above the text box to add the code tags to the code. After doing these steps, your code

Please Login or Register  to view this content.

after you save the post.

2) Do you have a sample workbook you can attach?

[demoman0602]

here it is

[Kenneth Hobson]

Before I get into more detail, try using this sub. Security issues can be a problem for some. Change [email protected] to yours.

Please Login or Register  to view this content.

[gmr4evr1]

Removed post about code tags because OP has added code tags.

[demoman0602]

Sorry got the code box format going now
The code works for the combobox and the send mail feature, im having an issue with what string i would need to combine the name, and dates to assemble them into the email so it can be sent

[Kenneth Hobson]

File attachments are not working for me right now so here is a link. It should give you some ideas.

https://www.dropbox.com/s/7heimzrdqj...form.xlsm?dl=0

[demoman0602]

File attachments are not working for me right now so here is a link. It should give you some ideas.

https://www.dropbox.com/s/7heimzrdqj...form.xlsm?dl=0

Thanks this makes it real clear