Set fso = CreateObject('Scripting.FileSystemObject') Thus we need a function which read and return the Signature Texts from the file wherever we need to insert it in the body of the Outlook email.įunction to read the Signature file and return the Signature Textįunction GetSignature(fPath As String) As String If yes then we are reading the text from the signature file and inserting that signature in the email. Click it and make sure it Ccs and Sends.In the below code we are first checking if these files exists and have some values in it. You should now see the button on your ribbon. Back on the right, Right Click on your macro, select rename, give it a name and select an icon. On the left, Select Macros, click on your macro and then click the Add > ButtonĦ. Right click on the New Group you just created and select Rename. Open a New Email Message -> Right Click on Ribbon -> Select Customize RibbonĢ. Replace with the email that you want to Cc. Copy and Paste the following code into the code window. Double Click “Project1->Microsoft Outlook Objects->ThisOutlookSession”. Click on Developer Tab -> Click on Visual Basic ButtonĢ. Open Outlook -> File -> Options -> Customize Ribbon -> Check the Developer Tabġ. It’s pretty straight-forward, but took me longer than it should of. I could have created a rule to always Cc myself, but I only want to occasionally Cc myself and didn’t want to have to clean all that up later. Up until today, I would manually add myself as Cc, but now I have a single button I can click that will add me as Cc and send the mail. This is useful when you want to make sure you don’t send an email with a request from someone and then forget about it. A big part of my Zero Inbox routine is to Cc myself when I want to be reminded to follow up on the mail.

Macro create outlook email