save & email

Hello all, so I do have a command button in my excel which first checks a few fields (they're not supposed to be empty and if there are an automated message box is created) and secondly sends the file attached to an email I now would like to extend the function of this message box - so after...

Hi, I have the VBA code below working perfectly on my PC windows: - Makes a copy of the required sheet (sheet 2 in this example) - Saves it as an xlsx format so all formulas and macros removed, just values and formatting kept. - Creates the filename using specified ranges given and file type...

Hi, I have adapted a great bit of code from Ron De Bruin that will create an email with grouped data depending on the email addresses. (Mail a row or rows to each person in a range) The code works great but depending on the data I have it can create upwards of 100 emails. The code as per Ron...

there seem to be lots of codes for this out there and I'm really close to getting it figured out.. I have a workbook that has 26 sheets, I want to create a macro that saves all sheets as hardcodes (completed) and creates a draft email in outlook with each sheet as an attachment. Created a...

Hello! I haven't written any code myself yet. But I have used recording macros & lots of google searches to get a few time savers for some of the work I do. I have one set of code that works to delete my autolook ups (basically it copy & pastes special so no vlookups are left), then it saves...

I'm trying to have an email auto generate after a workbook is saved. I don't want to send the workbook in the email, just an email notification to a list of people to say that the spreadsheet has a new entry so they actually have to open it and respond (if I could put a link to the location of...