Macro attached to e-mail with a change of subject

[McWuk]

Hi,

I'm quite new to the world of macro's, I can record them but not edit or write them myself.

Now, I want to create a macro which hides some of the tabs (I can do that with the recording) and attaches the Excel file to an e-mail where I can change the e-mailaddress but where the subject is named "PIF".
Note: the file can't be saved because the macro has to work for all users. We cannot save anything on the main directories or maps. Just in our own user documents.

Hopefully there is anyone out there who can help me to solve this issue.

Cheers.

Regards,

Niels

[dflak]

The following is my module for mailing a file. It requires that Outlook be installed and configured on the machine. It does not have to be running, but the user must be logged in. This macro takes 6 arguments that you can pass to it from another macro:
-To String (mandatory) - the list of To recipients separated by a semicolon.
-Subject String (mandatory) - the subject of the message
-Body String (mandatory) - the body of the message
-CC String (optional) - the list of CC recipients separated by a semicolon
-BCC String (optional) - the list of BCC receipitents separated by a semicolon
-Attachment Name (optional) - the name of a file to attach. - note: if you are attaching the workbook that is running this program do thisworkbook.save first.

So here is how it would be called for two emails in the To line, no CCs or BCCs and an attachment.

Mail_Workbook "email1@address1;email2@address2", "Subject of the message", "Body of the message",,,"\\ServerName\DirectoryName\WorkbookName.xlsx"

Please Login or Register  to view this content.

P.S. you can read any of the above parameters, such as email address, from a cell.