I have code that adds an excel sheet to outlook and also displays the spreadsheet in HTML - the code already attaches the workbook to the email but I would like to make an addition if possible.

Once a person chooses to add the file to outlook and send the email - I also need to attach other files from different locations along with the email - I would like to incorporate this attaching process to more automated.

Once it goes to create the Html in outlook and attach the excel workbook I would like a box to come up asking if you have any other files to attach to the email - and then at that time the user can attach the file of choice before the email is created.

If it can also have another pop up asking if there is another file to attach they can or if they have attached all files then it would finalize the process and create email.

One more thing we do have "2 files" we attach but if they are not zipped down Outlook does not allow them to come thru so in the attaching process I would like it to ask if the user would like the file to be zipped when it gets attached.

I hope this is possible it would help out my process greatly.

Thanks for any help