Put listbox items into email body

I have a userform to create an email. It generates the email body from textbox values within the userform. My problem is getting the listbox items into the email body.

Here are my code

Please Login or Register  to view this content.

After "please see attached" in the email body I would like the listbox items to go in there so the email reads;

Hi John,

Re: Project 1

Thank you for the opportunity to tender for the above project. Please see attached:

• Price BOQ
• Quality Submission
• Case Studies
• Programme

Please do not hesitate to contact me should you have any queries.

The "Price BOQ, Quality Submission, Case Studies, Programme" is just for this example but will be completely different for each email. I select checkboxes to populate the listbox with these items

Thanks for any help with this!

Hi Norie,

Thank you for your reply.

I have a textbox on the userform named txtboxBody. It is populated by running my code above on a click event.

I then have an email button that runs another code but it wont let me upload it.

Its with Createobject code and it has .HTMLbody = userform txtboxbody in it

How do I incorporate your code into mine then?

Thanks Norie!

Bakerman2,

Sorry for the late reply, I had to work away from home and only back.

Brilliant code as always. Could you get it to put selected folders as attachments in the emails also?

Thanks bakerman2 and sorry again for only getting back to you now

I have attached a file to show you what I am trying to achieve.

Can't quite get it working but its nearly there!

My idea was to create the whole email via userform. For the attachments box I was thinking I could click this box and it takes me to the project folder on J:/ and I can select the files I want to attach to the email.

For the body textbox I was wanting to add the standard preformatted text for all emails and then manually add more text to the email depending on the requirements for each project.

Can the email include my email signature at the bottom?

Thanks

Bakerman2,

brilliant as usual!!

Thank you

Only one wee thing. It brings up an error if there is nothing in the bullet points listbox.

Sometimes there will be no bullet points on the email so could this work if nothing is selected?

Thanks bakerman2 and Norie!