|
| 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. |
|
|||||||
|
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
June 27th 08, 10:28 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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. 
|
| Ads |
|
#2
June 27th 08, 10:57 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
June 27th 08, 11:23 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
June 28th 08, 12:42 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
June 30th 08, 06:51 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
July 1st 08, 05:56 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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.
|
|
#7
July 2nd 08, 06:05 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Create a Macro in Outlook
Hi Sue,
I am getting a Run-time error 424. Sub ms() ReplyMail.Subject = "#ms#" End Sub Is this how I should have macro. Thanks for your help. Bert "Sue Mosher [MVP-Outlook]" wrote: 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.
|
|
#8
July 2nd 08, 06:26 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Create a Macro in Outlook
Do you have other code that declares the ReplyMail object at the module level
and instantiates it? If not, Outlook has no way of knowing what ReplyMail refers to (and neither do we, because we don't know whether you want a macro that replies to a current message or whether you want a macro that acts on the currently display message). -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Bert" wrote: Hi Sue, I am getting a Run-time error 424. Sub ms() ReplyMail.Subject = "#ms#" End Sub Is this how I should have macro. Thanks for your help. Bert "Sue Mosher [MVP-Outlook]" wrote: 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 "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.
|
|
#9
July 2nd 08, 08:01 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Create a Macro in Outlook
No I do not have another code. A macro that replies to a current message and
adding the #ms# to the reply. "Sue Mosher [MVP-Outlook]" wrote: Do you have other code that declares the ReplyMail object at the module level and instantiates it? If not, Outlook has no way of knowing what ReplyMail refers to (and neither do we, because we don't know whether you want a macro that replies to a current message or whether you want a macro that acts on the currently display message). -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Bert" wrote: Hi Sue, I am getting a Run-time error 424. Sub ms() ReplyMail.Subject = "#ms#" End Sub Is this how I should have macro. Thanks for your help. Bert "Sue Mosher [MVP-Outlook]" wrote: 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 "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.
|
|
#10
July 2nd 08, 08:28 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Create a Macro in Outlook
I GOT IT SUE. And it works as follows:
Sub ms() Set objItem = Application.ActiveInspector.CurrentItem objItem.Subject = "#ms# " & objItem.Subject End Sub Thank you for being patient with me. "Bert" wrote: No I do not have another code. A macro that replies to a current message and adding the #ms# to the reply. "Sue Mosher [MVP-Outlook]" wrote: Do you have other code that declares the ReplyMail object at the module level and instantiates it? If not, Outlook has no way of knowing what ReplyMail refers to (and neither do we, because we don't know whether you want a macro that replies to a current message or whether you want a macro that acts on the currently display message). -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Bert" wrote: Hi Sue, I am getting a Run-time error 424. Sub ms() ReplyMail.Subject = "#ms#" End Sub Is this how I should have macro. Thanks for your help. Bert "Sue Mosher [MVP-Outlook]" wrote: 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 "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 |
| Display Modes | |
|
|
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 |
Linear Mode
