VBA Code Samples

The following is the Save Attachment code sample from Teach Yourself Outlook 2003 in 24 Hours. (It works in current versions.) Frank modified the code to break it into a single call for each mail item so you can use it with a rule to filter incoming mail. Augusto modified Frank's code "in order to avoid  

How to move or import appointments from an Outlook calendar into a Group Calendar.

A user had a request: an automated way of telling people a meeting full. It's not an unusual request, 3 or 4 people ask me how to do this each year. This time it sounded like a fun project to do. I am in charge of organizing meetings for my company (150+ people). However, depending  

I'm going to begin this by saying that I really think it's time to find another solution for journaling. I have no idea how many more versions we'll see before Microsoft rips Journal's heart out. It's time to move on to something that is going to be around longer. On the other hand, it's possible  

Use this code to send a new message using the address the selected message was sent to as the From account. This code is for people who use an account such as Gmail or Hotmail to collect mail from other accounts. Outlook will always reply using the account that downloaded the message, this code selects the send using account based on the address the message was sent to.

A user had this question: I want to do the following: Copy a message from one public folder to another public folder Mark the original message as read Mark the original Complete Add a Category to it A Quick Step will categorize the e-mail first (it has a higher priority) and both the actual e-mail  

One (very justified) complaint about Outlook recurrence patterns is that there is not a pattern for Every xx weekday (Monday - Friday). You can create appointments for specific days of the week, but the every xx days pattern includes Saturday and Sunday. The solution: a macro that copies the appointment details to a new appointment.

How to use VBA to automatically open up Outlook windows in a particular order (mail, calendar, contacts and tasks) with each in a specific size and screen position.

Macro to replace the Go To Date feature of Outlook's Calendar. From an open appointment, run the macro. The calendar opens to the date of the appointment.

A visitor to our forums had a question about time zones: I regularly need to schedule events in Pacific and Eastern time. Is there a way to get rid of all the excess time zones? For example, I counted *six* different entries for UTC-5 (US eastern time). I get that there are places with weird  

How to use a macro to mail merge to email, add attachments, and send the messages from a different email address.

Outlook 2013 doesn't set a reminder when you open a new appointment form by double clicking on a date in the monthly calendar. Until Microsoft fixes this, you can use a macro to set the reminder.

A visitor to Slipstick Forums had a problem: I need to count the inbound traffic by inbox/day and check whether the email was marked as complete (Flag Completed Date and Time). I can get the time when I copy and paste from a folder to Excel but there are a number of folders to process  

The problem: a user needs to file messages from clients in a specific folder, which is the clients accounts number. Moving the messages manually is time consuming but using a macro makes it easy.

Outlook VBA code to remove the +1 country code prefix and reformat phone numbers in Outlook Contacts before syncing to a smartphone.