help editing my code that emails a range of data via outlook.

Hi guys,

I have a piece of code that I got online and have slightly tweaked.

I would like to add the following feature.

1) When excel creates the temporary excel file I would like it to ask teh user to input a name they would like to call the file. (The file that will be e-mailed), I would prefer this over having to input a standard name in the code.

2) I would like excel to ask the user who they would like to e-mail the file to and they can input the e-mail address in an input box, which then populate into outlook "to" field before it opens. (This feature isn't as necessary)

Any help would be great!

Please Login or Register  to view this content.

The code works great except for one thing.

The code changed the Subject line of the e-mail instead of the temporary excel file name.

Could you kindly correct this for myself ? I want to have it as the Fname + todays date/time.

Thank you so much!

Could I ask you one last thing ebfore I resolve this thread.

If you press cancel or the x button, you will get an Error 400. Is it possible to change this so that it simply ends the sub without creating a temporary excel file?

This could be for a situation where someone has accidentally started this macro by clicking a command button but they would like to cancel it.

I tried putting an error handler in and it worked, but it still created a temporary excel file.

Any help would be great!