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

Create a Macro in Outlook



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 27th 08, 10:28 PM posted to microsoft.public.outlook.program_vba
Bert
external usenet poster
 
Posts: 11
Default Create a Macro in Outlook

Hello. I am having a challenging time creating a macro in Outlook. I'm
trying to create a macro when replying to an email, in the Subject line will
automatically populate #ms#. Which MS is how our Mail Secure of how
confidential data flows through.
  #2  
Old June 27th 08, 10:57 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Create a Macro in Outlook

Where are you encountering problems? Exactly how do you want the Subject line to look -- does #ms# replace, precede, or follow the standard prefix?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Bert" wrote in message ...
Hello. I am having a challenging time creating a macro in Outlook. I'm
trying to create a macro when replying to an email, in the Subject line will
automatically populate #ms#. Which MS is how our Mail Secure of how
confidential data flows through.

  #3  
Old June 27th 08, 11:23 PM posted to microsoft.public.outlook.program_vba
Bert
external usenet poster
 
Posts: 11
Default Create a Macro in Outlook

I'm having problems with the Outllok Codes, since Outlooks does not record
macros. The #ms# would follow the standard prefix.

"Sue Mosher [MVP-Outlook]" wrote:

Where are you encountering problems? Exactly how do you want the Subject line to look -- does #ms# replace, precede, or follow the standard prefix?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Bert" wrote in message ...
Hello. I am having a challenging time creating a macro in Outlook. I'm
trying to create a macro when replying to an email, in the Subject line will
automatically populate #ms#. Which MS is how our Mail Secure of how
confidential data flows through.


  #4  
Old June 28th 08, 12:42 AM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Create a Macro in Outlook

Though no macro recorder is available (and the same is true for most Office programs), there is a huge amount of Outlook sample code available, included that in the Help system itself. Where in particular are you stumped?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Bert" wrote in message ...
I'm having problems with the Outllok Codes, since Outlooks does not record
macros. The #ms# would follow the standard prefix.

"Sue Mosher [MVP-Outlook]" wrote:

Where are you encountering problems? Exactly how do you want the Subject line to look -- does #ms# replace, precede, or follow the standard prefix?

"Bert" wrote in message ...
Hello. I am having a challenging time creating a macro in Outlook. I'm
trying to create a macro when replying to an email, in the Subject line will
automatically populate #ms#. Which MS is how our Mail Secure of how
confidential data flows through.


  #5  
Old June 30th 08, 06:51 PM posted to microsoft.public.outlook.program_vba
Bert
external usenet poster
 
Posts: 11
Default Create a Macro in Outlook

I am new to this I am stumped at the following:

Sub ms()
ReplyMail.Subject = "#ms#"(remainder of the subject)
End Sub

Thanks for your assistance.

"Sue Mosher [MVP-Outlook]" wrote:

Though no macro recorder is available (and the same is true for most Office programs), there is a huge amount of Outlook sample code available, included that in the Help system itself. Where in particular are you stumped?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Bert" wrote in message ...
I'm having problems with the Outllok Codes, since Outlooks does not record
macros. The #ms# would follow the standard prefix.

"Sue Mosher [MVP-Outlook]" wrote:

Where are you encountering problems? Exactly how do you want the Subject line to look -- does #ms# replace, precede, or follow the standard prefix?

"Bert" wrote in message ...
Hello. I am having a challenging time creating a macro in Outlook. I'm
trying to create a macro when replying to an email, in the Subject line will
automatically populate #ms#. Which MS is how our Mail Secure of how
confidential data flows through.


  #6  
Old July 1st 08, 05:56 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Create a Macro in Outlook

Just as the + operator is used to add two numbers together, the & operator is
used to join two strings together:

ReplyMail.Subject = "#ms#" & ReplyMail.Subject

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx



"Bert" wrote:

I am new to this I am stumped at the following:

Sub ms()
ReplyMail.Subject = "#ms#"(remainder of the subject)
End Sub

Thanks for your assistance.

"Sue Mosher [MVP-Outlook]" wrote:

Though no macro recorder is available (and the same is true for most Office programs), there is a huge amount of Outlook sample code available, included that in the Help system itself. Where in particular are you stumped?



"Bert" wrote in message ...
I'm having problems with the Outllok Codes, since Outlooks does not record
macros. The #ms# would follow the standard prefix.

"Sue Mosher [MVP-Outlook]" wrote:

Where are you encountering problems? Exactly how do you want the Subject line to look -- does #ms# replace, precede, or follow the standard prefix?

"Bert" wrote in message ...
Hello. I am having a challenging time creating a macro in Outlook. I'm
trying to create a macro when replying to an email, in the Subject line will
automatically populate #ms#. Which MS is how our Mail Secure of how
confidential data flows through.


 




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
How do I create a macro for Outlook 2007? Lost old in conversion lmf Outlook and VBA 6 May 23rd 08 06:49 PM
How do I create a new macro in Outlook 2007? Srta Evita Outlook - General Queries 3 May 20th 08 09:09 AM
create Macro, Outlook 2007 - create is grayed out Dave Horne[_2_] Outlook - General Queries 2 November 4th 07 09:45 AM
how do I create a macro in Outlook Philip Raymond Outlook and VBA 2 April 25th 07 07:20 PM
create a Outlook macro which will check for non arrival of mail srisubha Outlook and VBA 3 November 2nd 06 07:04 AM


All times are GMT +1. The time now is 05:11 PM.


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