Hi all,

Long time lurker, first time poster, so be gentle! I'm looking for a VBA code that will protect the entire workbook, then create an email in Outlook with the protected workbook attached (like with the Save & Send option) and pre-specified text in the email header and email body (depending on defined names within the workbook)... Let me have a go at explaining...

In my workbook I have various boxes and dropdown menus that need to be filled in before the email is allowed to be sent. The current names I have defined which need to be populated are:

_Recipient_Name
_Email
_ClientName
_Reference
_Product
_ProductNumber
_Email_Subject - this is a combination of the various other inputs above, plus others

So far I have this VBA code which is close but attaches the unsaved, unprotected workbook (i.e. with no changes since last opened). Any help would be massively appreciated!

Formula: copy to clipboard 
Please Login or Register  to view this content.


My VBA skills are pretty weak (Only been doing it for a few weeks and most info I've found has been online so I'm not 100% sure how it all works) so any help - as simple as possible - that can be given would be awesome!

Cheers,

Mogles