(Msg. 1) Posted: Fri Jun 27, 2008 2:28 pm
Post subject: Create a Macro in Outlook Add to elertz Archived from groups: microsoft>public>outlook>program_vba (more info?)
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.
(Msg. 2) Posted: Fri Jun 27, 2008 5:57 pm
Post subject: Re: Create a Macro in Outlook Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.TakeThisOut@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.
(Msg. 3) Posted: Fri Jun 27, 2008 5:57 pm
Post subject: Re: Create a Macro in Outlook Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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?
>
> --
> 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" <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.
>
(Msg. 4) Posted: Fri Jun 27, 2008 7:42 pm
Post subject: Re: Create a Macro in Outlook Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
>>
(Msg. 5) Posted: Mon Jun 30, 2008 10:51 am
Post subject: Re: Create a Macro in Outlook Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <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.
> >>
>
(Msg. 6) Posted: Tue Jul 01, 2008 9:56 am
Post subject: Re: Create a Macro in Outlook Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <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.
> > >>
> >
(Msg. 7) Posted: Wed Jul 02, 2008 10:05 am
Post subject: Re: Create a Macro in Outlook Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <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.
> > > >>
> > >
(Msg. 8) Posted: Wed Jul 02, 2008 10:26 am
Post subject: Re: Create a Macro in Outlook Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.TakeThisOut@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.TakeThisOut@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.
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office