Create a Macro in Outlook

External Since: Mar 06, 2006 Posts: 32

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" <Bert.DeleteThis@discussions.microsoft.com> wrote in message news:6BC749CD-0C8B-49B3-8DC3-71C73666299C@microsoft.com...
> > > > > > I'm having problems with the Outllok Codes, since Outlooks does not record
> > > > > > macros. The #ms# would follow the standard RE: 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 RE: prefix?
> > > > > >>
> > > > > >> "Bert" <Bert.DeleteThis@discussions.microsoft.com> wrote in message news:9B629EF2-9E65-45C7-96C0-C571EDC90CF9@microsoft.com...
> > > > > >> > 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.
>

External Since: Mar 06, 2006 Posts: 32

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" <Bert RemoveThis @discussions.microsoft.com> wrote in message news:6BC749CD-0C8B-49B3-8DC3-71C73666299C@microsoft.com...
> > > > > > > I'm having problems with the Outllok Codes, since Outlooks does not record
> > > > > > > macros. The #ms# would follow the standard RE: 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 RE: prefix?
> > > > > > >>
> > > > > > >> "Bert" <Bert RemoveThis @discussions.microsoft.com> wrote in message news:9B629EF2-9E65-45C7-96C0-C571EDC90CF9@microsoft.com...
> > > > > > >> > 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.
> >