Help! I am not at all an advanced excel user and our excel guru has moved on to greener pastures. I need to create a macro that when the user finishes filling out the fields in a spreadsheet it does the following: Prompts the user to save the document with a semi filled out document name eg Letter of Offer [Name]. I would like the Letter of Offer part to stay and them have to enter the new employees name so the the document will be saved as Letter of Offer Joe Bloggs Then sends the current worksheet to a specified email address Any help would be greatly appreciated, I am currently using Microsoft Excel version 2010 and only have very basic skills... Helen :confused:

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Macro to prompt user to save the excel file and then email only the current worksheet to a specified address

Thread starter HelenWarren
Start date Jun 9, 2015

HelenWarren

New Member

Jun 9, 2015

Help! I am not at all an advanced excel user and our excel guru has moved on to greener pastures. I need to create a macro that when the user finishes filling out the fields in a spreadsheet it does the following:

Prompts the user to save the document with a semi filled out document name eg Letter of Offer [Name]. I would like the Letter of Offer part to stay and them have to enter the new employees name so the the document will be saved as Letter of Offer Joe Bloggs
Then sends the current worksheet to a specified email address

Any help would be greatly appreciated, I am currently using Microsoft Excel version 2010 and only have very basic skills...

Helen