userform to choose sheets and send them by email

[chingilou]

More than 1 file attachment would require more work. First off though, you need to get the yahoo email to work. Post back when you get that working. Manually set an existing file attachment path like I did for that last input parameter value, "D:\t\f.txt". Doing many attachments like this complicates my #12 solution but is no real challenge. The challenge is figuring out what "you" want to attach. I guess that I would put the paths into an array and iterate that.

well i will start tomorrow with a predefined file

For (1), Graham built the array dynamically from the selections in the userform. In #4, I showed how to manually create the array and he took it from there.

I lack document to understand all the functions done by graham and you
I'm a little used to uvba but never userform I know nothing that's why I swim blindly

Another method for (1) is to select the sheets as a group. This is how you do this method manually: hold ctrl key down, and click the sheets to select them for the group. Select File > Export > PDF, etc. And there you go, a multiple worksheet pdf. Graham, this is where we would Worksheets(1).Select True, and then if others, use False. It is a simple method. I use a boolean tf variable to know if I need to set True or False. One does need to deselect the group (select another sheet) at the end of pdf creation.

manually I know how to do it, it is by vba that I do not know
in the same way the first graham file does it elsewhere
by modifying spath and deleting kill ...
but I would like to isolated this part for the create pdf only command button

Before I show you how to do (2), do as I said and try just making #12 work. If that does not work for you, adding the multiple attachments feature won't either. Of course adding all pdf files from a folder is different than anything discussed before. I guess one could but that is more code to handle cases of no pdfs and a loop for multiple .addattachement lines.

watch graham's first file
if I chose the 5 I would have 5 pdfs files as the photo shows on the right.
and I have the 5 attachments for outlook

the whole solution of the problem the first graham file does it but this is the way I would like to change
textboxes instead of listboxes and if possible yahoo instead of outlook
and a command button in the middle of the step for creating only pdfs without sending