How do I use a rule to reply to an email?

**RichardM** · April 13th 07, 05:58 PM posted to microsoft.public.outlook.program_vba

Thanks again! I'll give that a try.

"Michael Bauer [MVP - Outlook]" wrote:

In VBA IDE (ALT+f11) please open the object browser (f2) and switch from
All libraries to Outlook.

On the left pane select 'Items', on the right one the 'ItemAdd' event. Then
press f1 for a sample which shows you how to receive that event.

The event procedure could look like this:

Private Sub Items_ItemAdd(ByVal Item As Object)
Dim Mail As Outlook.MailItem

If TypeOf Item is Outlook.MailItem Then
set Mail = item

' checks the address, it's not case sensitive
If LCase$(Mail.SenderEMailAddress) = LCase$("...") Then
' go on here

Endif
Endif

End Sub

You can see all of the MailItem's properties in the object browser, too. If
the mail is from your vendor then you probably need to parse its Subject
property. Please see the help file for how to use the Instr, Left, and Right
functions for that.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - The most effective way to assign Outlook categories:
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am Thu, 12 Apr 2007 07:16:02 -0700 schrieb RichardM:

Thanks for the info Michael, however, I do not know how to construct a
macro
(which is what I assume you're suggesting). Can I get specifics please?

Thanks again

"Michael Bauer [MVP - Outlook]" wrote:

You can use the ItemAdd event of the Inbox for that, it tells you when a
new
message arrives. In that event check the item's SenderEMailAddress and
Subject. If it's an item you want to reply on then call it's Reply
function.
That function returns a new MailItem object. You can edit it's Subject
property and call the Send method.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - The most effective way to assign Outlook categories:
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am Wed, 11 Apr 2007 14:10:01 -0700 schrieb RichardM:

Here's my problem. I am trying to figure out how to setup a rule in
Outlook
2003. On a daily basis, I receive 3 - 5 separate emails, from an
outside
vendor, containing files for my review. Each subject line is unique and
contains the name of the file being sent. I would like a rule which
would
acknowledge each file and do it so the sender knows which file has been
received, i.e. â€˜ FileA Receivedâ€™, â€˜ FileB receivedâ€™, etc.

Will I need a special macro or can I use the built-in rules for Outlook
to
accomplish this task. I do not have the knowledge to script a macro.
Any
help would be greatly appreciated.

Thanks!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Email Rule Question	Ralph Page	Outlook - General Queries	5	October 16th 06 01:27 PM
FYI -Creting server based outo reply rule in outlook	CAMC1	Outlook - General Queries	0	August 1st 06 06:26 PM
Multiple email rule	VinceT	Outlook Express	4	March 20th 06 10:46 PM
Change "Reply To" Rule	[email protected]	Outlook and VBA	0	March 1st 06 09:47 AM
Auto reply rule within Outlook 2003	WetBehindEars	Outlook - Installation	1	February 15th 06 07:59 PM