A friend sent me a spreadsheet with a list of dates. He wants to put them on his calendar as vacation days, but doesn't want to do it manually. Hooray, another free job.
Continue Reading: Adding vacation days to Outlook in bulk from Excel »
Automatically attach a file to all outgoing messages
January 27, 2010 by · 
Someone on Outlook Code asked about automatically attaching a file to new messages. You could do this two ways:
- Create a new message programmatically and attach the file.
- Use the ItemSend Event to attach the file to all outgoing messages.
Here I'll demonstrate the first way, since I've already posted code for the second way. (see Attach files to an Outlook email using VBA)
Continue Reading: Automatically attach a file to all outgoing messages »
Create Distribution Lists from Email
December 28, 2009 by · This is the next post in the Save money, use VBA series.
Continue Reading: Create Distribution Lists from Email »
Tally Ho: Sending and counting voting responses in Outlook using VBA
December 7, 2009 by · A structured and simple way to send out a simple survey using Outlook is to use the voting options available in an email message. You'll see them when you open an email (in Outlook 2003) and click the Options button on the Standard toolbar:
Continue Reading: Tally Ho: Sending and counting voting responses in Outlook using VBA »
Using Excel VBA to set up Task Reminders in Outlook
November 2, 2008 by · I know I have trouble remembering when different projects or tasks are due. Here's one way to remember: Set up a list of tasks and due dates in Excel, then use VBA to set up reminders in Outlook.
Continue Reading: Using Excel VBA to set up Task Reminders in Outlook »
Follow Me