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

Tags: , ,

edit message macro





 
 
Thread Tools Display Modes
  #1  
Old June 18th 06, 01:08 PM posted to microsoft.public.outlook.program_vba
BorisS
external usenet poster
 
Posts: 37
Default edit message macro

I am used to Excel with VBA, but am new to OL. I need to have a key that
runs a macro which does the following:

1) opens selected messages
2) puts message into edit mode
3) highlights subject text

I will then change the subject text and exit/save out of the message.

Can anyone help with the code (I'm guessing it has to be pretty short) for
the above three steps, and also let me know where I'd place this code in OL
VBA?

Thanks.
--
Boris
Ads
  #2  
Old June 19th 06, 06:28 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default edit message macro

Am Sun, 18 Jun 2006 04:08:01 -0700 schrieb BorisS:

You can place the code into the module "ThisOutlookSession", it has to be
Public with no parameters.

The selected message are in the Application.ActiveExplorer.Selection
collection. For changing the subject you donīt need to open a message, but
just write the next text into its Subject property, and donīt forget to save
the message.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


I am used to Excel with VBA, but am new to OL. I need to have a key that
runs a macro which does the following:

1) opens selected messages
2) puts message into edit mode
3) highlights subject text

I will then change the subject text and exit/save out of the message.

Can anyone help with the code (I'm guessing it has to be pretty short) for
the above three steps, and also let me know where I'd place this code in

OL
VBA?

Thanks.

 




Thread Tools
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
Macro to kick in every time I send a message Jyoti Outlook and VBA 5 May 27th 06 12:04 PM
EDIT NAME IN OUTLOOK FROM-- ORIGINAL MESSAGE --FROM raoney75 Outlook - Installation 1 April 6th 06 10:04 PM
Edit Default Message Field Trendy Wendy Outlook - Using Forms 2 February 9th 06 05:42 PM
Macro within a Mail Message Tia Outlook and VBA 1 February 7th 06 03:47 PM
Troubles adding a macro to Mail Message - help please spam@portz.ca Outlook and VBA 4 January 27th 06 12:01 AM


All times are GMT +1. The time now is 03:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright Đ2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Loans - Personal Finance - Xecuter 3 Mod Chip - Mortgage Loans - Loans