Welcome to Office Zealot Sign in | Join | Help

New Article: Getting a Handle on Your E-mails with VBA

I've written a new “article“ (instead of a “post“ - what the heck is the real difference anyway?) on Outlook VBA.  This is meant to be a nice little overview on working with e-mail messages programmatically - how, when and where you can do some funky stuff with your macros.

See the article at http://blogs.officezealot.com/legault/pages/20086.aspx.

BTW, stay tuned to Microsoft Office Online and MSDN for a pair of Outlook articles that I'm finishing up - one on sharing your Outlook information, and another based on one of my previous blogs that show a better way of working with multiple picture attachments.

In other completely unrelated news, I parred two holes in a row today!  And my Delete key for some reason isn't working in this text box only what the @%!&@...  Hey, it's working now.  Aren't blogs great?

Published Friday, August 06, 2004 11:45 PM by legault
Filed under: ,

Comments

# moving text to a specific contact field text box

Hi Eric. Love the site and i'm reading through a number of articles.
I found your code on how to create a contact card automatically from a recieved email and it is wonderful!!!

So forgive me if you've already posted this.
I'm sure that alot of outlook users may wonder about how they might move a line of text in and outlook message, to a field in their contact list using VBA.

For instance, if a person sent a message that said.. hey my Phone number is (416)555-1234 is there a way to use vba to copy that phone number and paste it into the that individuals Contact Card.

thank you again.
Cheyenne
alvisc2002@yahoo.com
Thursday, February 02, 2006 8:48 AM by Anonymous

# re: New Article: Getting a Handle on Your E-mails with VBA

Cheyenne: Sorry for the delay in my reply - I somehow missed this comment. You can access the text in a message via the Body or HTMLBody property. However, you'll have to use some general VB string functions such as InStr, Left, Mid, etc. to parse the message and search for a phone number. Once you have that, it's easy to update a Contact item with that value.
Tuesday, May 02, 2006 8:12 AM by legault
Anonymous comments are disabled