A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook VBA Macros



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old March 5th 09, 08:12 PM posted to microsoft.public.outlook.program_vba
MCPAlvarez
external usenet poster
 
Posts: 1
Default Outlook VBA Macros

Hello,

I'd like a button on the toolbar of a new Outlook 2003 message that does a
few things (macro).

First it checks two options under "Voting and Tracking options" under
"Message Options", "Request a delivery receipt...." and "Request a read
receipt..."for this specific message.

Then i'd like for the macro/vba to attach the following file
"C:\FTPLOG\ftp.log"

Then I would like for it to automatically "Send" the message.

Lastly, I would like for it to delete the file it just sent
"C:\FTPLOG\ftp.log", to be ready for the next transmission.

Where do i even start to get this going? Please help...thanks in advance,
really thanks.

MCPAlvarez
Ads
  #2  
Old March 6th 09, 07:17 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Outlook VBA Macros



You can access the selected item of a folder with the Selection collection
of the ActiveExlorer object. Or use ActiveInspector.CurrentItem for an
opened item.

See the MailItem object in the object browser (f2) and what properties and
methods are available, for instance ReadReceiptRequested.

Via Attachments.Add you can add a file. If there's no recipient yet, add one
via Recipients.Add. Eventually call the Send method.

For every mentioned property or method select it in the object browser, and
click f1 for more help and a VBA example.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Thu, 5 Mar 2009 12:12:01 -0800 schrieb MCPAlvarez:

Hello,

I'd like a button on the toolbar of a new Outlook 2003 message that does a
few things (macro).

First it checks two options under "Voting and Tracking options" under
"Message Options", "Request a delivery receipt...." and "Request a read
receipt..."for this specific message.

Then i'd like for the macro/vba to attach the following file
"C:\FTPLOG\ftp.log"

Then I would like for it to automatically "Send" the message.

Lastly, I would like for it to delete the file it just sent
"C:\FTPLOG\ftp.log", to be ready for the next transmission.

Where do i even start to get this going? Please help...thanks in advance,
really thanks.

MCPAlvarez

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
macros vs. VBA in outlook 2003 tom Outlook and VBA 9 February 2nd 09 10:05 PM
Outlook 2007 and macros Ratzaz Outlook - Installation 1 September 17th 08 09:23 PM
using macros in Outlook Roger Outlook - General Queries 1 September 17th 07 05:43 PM
How to use macros in Outlook? Roger Outlook and VBA 1 September 17th 07 04:52 PM
Outlook Macros - VB code Ted Martin Outlook and VBA 1 February 22nd 07 03:30 PM


All times are GMT +1. The time now is 05:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.