How do I convert Excel Serial Values in an Outlook message body using VBA?
Lets say 37257 is in the body and I want to convert it to January 31, 2004.
Will VBA do it?

From Excel I wish to choose a selected outlook folder and read the email
header information (from to subject etc) and create the list in an Excel
worksheet.  Is this possible?  If so how can I determine the list of
folders, whether they contain email items, and then access the ...

I have some clients who e-mail me and their e-mail comes out as
<excerpt><bold><color>. I'm sure it's a pretty common occurrence.
What I would like to do is create a little macro such that I could
select text, press a hot key, edit the message and take the selection

Since Oulook 2003 cannot synchronize the public folder with a personal folder
I would like to create a macro to copy the public contacts folder (or all
entries within) to a new folder on my local contacts on a regular basis to
ensure the contacts are always up to date. The reason ...

I'm using the following code:
With objContact
   .FullName = objRecip.Name
   .Email1Address = strAddress

I have an Outlook COM Addin which adds toolbar buttons and menus. Images
are added to the CommandBarButtons using the following code (Clipboard
is a VB object)
   Clipboard.SetData LoadResPicture(CStr(myPic), _

Hello group,
I posted this to excel programming NG and have not recieved a useable
response, so I will try here.
I have a macro that emails a copy of a worksheet to a list of recipients

Looking for an add-in or VB code that will strip away the email signature
threading within all replies in an email message so there is only one
signature, which is located at the bottom.

I am new to Outlook VB applications, but not new to Vb. How can i filter
incoming email based on the values of thier titles and subjects. Basically,
if the email is from this perosn, i want it to add this value to a text file.
Im not intrested in the textfile part of it, but i ...

I'm trying to disable a command bar that has occassionally caused problems
in a custom form.  I came up with this routine:
Sub SetCmdBars(ByVal boolVal)
Dim oF

This is sort of an out of office issue. Certain emails come legitimately to
me but if I am out of the office, I want them to go to another person. The
other person should not normally get them. Only when I am out. So I can
create a rule to redirect and turn it on while I am gone. ...

Is there any way to create a mail message with an HTML formatted table in
the body section, using CDO 1.2.1 library? If so, how?
Thank you all

I'm still trying to solve the problem with my code that stops working after
249 items (see my other query on that topic), but this is a more general
question. Where can I find out more about the limit of 255 open RPC channels?
Is this a concurrent limit? How can I force a channel ...

please can someone tell me how to programmatically manage the Blocked
Senders list in OL 2003 . I want to be able to add any address I choose
via VBA or VB. net- thanks
R

Can someone give me a few clues to write a macro that will add a selected
email to the junk mail list then delete the same email?  I'm familiar with
Excel VBA but never done any VBA with Outlook, so I'm not familiar with any
of the Outlook objects, methods, etc.