Save excel file w/o prompts before attaching to email

[cmorten82]

I need to be able to save a file on our server and have multiple people access this file and fill it out and then click a button on that tab which would then save the file to their local machine and then attach it to an outlook email.

I have the VBA to attach the file and it attaches but it only attaches the file without the changes and I need it to save so it attaches the file to Outlook with the changes that the person made. I would like to add the code into my existing if possible but I am not versed enough in VBA to do so.

Please Login or Register  to view this content.

[Logit]

.
If your present macro code (In your post #1) works as desired, just instruct the users to SAVE THE WORKBOOK BEFORE pressing the button that creates the email.

Or, if you want to absolutely make certain the workbook is saved before they email it ... place this line of code

Please Login or Register  to view this content.

just below the header of
your email macro ...

Please Login or Register  to view this content.

[Logit]

.
If your present macro code (In your post #1) works as desired, just instruct the users to SAVE THE WORKBOOK BEFORE pressing the button that creates the email.

Or, if you want to absolutely make certain the workbook is saved before they email it ... place this line of code

Please Login or Register  to view this content.

just below the header of
your email macro ...

Please Login or Register  to view this content.

[cmorten82]

Thanks Logit! I thought it would have been more difficult than that but that worked perfect.

[Logit]

.
You are welcome.