Send Email to various recipents based upon Tick Box Selection

[ccsher77]

Hi All,


I am hoping you can help, I am currently working on a project which requires the operator to request (via email) a number of documents from various departments.


I have a standard list of 40 documents which may need to be requested.


However the documents are relate to different departments, i.e Documents 1-10 are required from Purchasing, Docs 11-20 from Sales, Docs 21-30 from Accounts etc., but the requirement for the specfic documents may change each time. for instance one customer may only require documnet number 7, 16 & 29 others may require all 40.


What I am looking to do is to set up a sheet or userform which lists all 40 docs and then place a tick box next to each item.

Then based on the customer requirements the Operator simply ticks the document titkes required.( I can do this part no ptoblem)


I then want to allow the operator to click a command button which will create email or emails (via outlook) listing the docs ticked as the main body of the mail.


Again I ahve a code which I found which allows me to create a blank email but I cannot figure out how I add the ticked items to it.


Can anyone help?


Thanks in advance

 

[Luke M]

One possible setup...

Have all of your tickboxes linked to a group of cells, say A1:A40

Code runs through that block of cells, checking for True value. If found, include name of document and add appropriate email to To list.


Several example of mail code can be found here:

http://www.rondebruin.nl/win/section1.htm