Send and save VBA Code

[Sovereignty9]

Can anyone help me??

Please look at the code below vba coding I have used on a work spreadsheet. First lot of coding Is the main coding I want rectified however I'm struggling with the automated save bit, and I do not want it too be a temporary copy that is deleted. I want the code to ensure that when the assigned button is clicked to automatically save it to a certain location as "Rosti Sills Delivery Check DDMMYYY". You can see from the code below send and save that I have got this to happen on a stand alone save button but unable to make it work when send an email at the same time.

Can anyone please help and suggest some changes to get this working as required.

Much appreciated

JoeJoe

Please Login or Register  to view this content.