How do i add the date to subject header of incoming mail?

  • Thread starter Thread starter primed
  • Start date Start date
Status
Not open for further replies.
P

primed

Hi,

How do i automatically add the date yy/mm/dd to the front of the subject

header of incoming mail? Would gather its something to do with create rules

then run script, but cant workout how to create a script.

Thanks

Primed
 
The script that can be run by a rule must look like this:

Public Sub Whatever(Mail as Outlook)

Mail.Subject=Date & " " & Mail.Subject

Mail.Save

End Sub

Best regards

Michael Bauer

Am Wed, 31 Mar 2010 22:47:01 -0700 schrieb primed:


> Hi,

> How do i automatically add the date yy/mm/dd to the front of the subject
> header of incoming mail? Would gather its something to do with create

rules
> then run script, but cant workout how to create a script.

> Thanks
> Primed
 
Hi Michael,

It came up with a run error.

Any ideas?

Thanks

Primed

"Michael Bauer " wrote:



> The script that can be run by a rule must look like this:

> Public Sub Whatever(Mail as Outlook)
> Mail.Subject=Date & " " & Mail.Subject
> Mail.Save
> End Sub

> > Best regards
> Michael Bauer
> Category Manager -

> SAM - The Sending Account Manager:
>

> Am Wed, 31 Mar 2010 22:47:01 -0700 schrieb primed:
>
> > Hi,
> > How do i automatically add the date yy/mm/dd to the front of the subject
> > header of incoming mail? Would gather its something to do with create
> rules
> > then run script, but cant workout how to create a script.
> > Thanks
> > Primed
> .
>
 
Sorry, the first line should look like this:

Public Sub Whatever(Mail as Outlook.MailItem)

Best regards

Michael Bauer

Am Mon, 5 Apr 2010 17:41:02 -0700 schrieb primed:


> Hi Michael,

> It came up with a run error.
> Any ideas?

> Thanks
> Primed

> "Michael Bauer " wrote:
>
>

>
>> The script that can be run by a rule must look like this:
>

>> Public Sub Whatever(Mail as Outlook)
> > Mail.Subject=Date & " " & Mail.Subject
> > Mail.Save
> > End Sub
>

>> > > Best regards
> > Michael Bauer
> > Category Manager -

> > SAM - The Sending Account Manager:
> >

>
>
>> Am Wed, 31 Mar 2010 22:47:01 -0700 schrieb primed:
> >
> >> Hi,
> >
>>> How do i automatically add the date yy/mm/dd to the front of the subject
> >> header of incoming mail? Would gather its something to do with create
> > rules
> >> then run script, but cant workout how to create a script.
> >
>>> Thanks
> >> Primed
> > .
> >
 
Cheers, that works better.

Can the date be reversed so its like this 100407

Also can the files attached to the document be renamed to have the same date

before them.

Thanks

Primed

"Michael Bauer " wrote:



> Sorry, the first line should look like this:

> Public Sub Whatever(Mail as Outlook.MailItem)

> > Best regards
> Michael Bauer
> Category Manager -

> SAM - The Sending Account Manager:
>

> Am Mon, 5 Apr 2010 17:41:02 -0700 schrieb primed:
>
> > Hi Michael,
> > It came up with a run error.
> > Any ideas?
> > Thanks
> > Primed
> > "Michael Bauer " wrote:
> >
> >
> >
> >> The script that can be run by a rule must look like this:
> >
> >> Public Sub Whatever(Mail as Outlook)
> >> Mail.Subject=Date & " " & Mail.Subject
> >> Mail.Save
> >> End Sub
> >
> >> > >> Best regards
> >> Michael Bauer
> >> Category Manager -

> >> SAM - The Sending Account Manager:
> >>

> >
> >
> >> Am Wed, 31 Mar 2010 22:47:01 -0700 schrieb primed:
> >
> >>> Hi,
> >>
> >>> How do i automatically add the date yy/mm/dd to the front of the subject
> >>> header of incoming mail? Would gather its something to do with create
> >> rules
> >>> then run script, but cant workout how to create a script.
> >>
> >>> Thanks
> >>> Primed
> >> .
> >>
> .
>
 
The script doesnt run when the rule is initiated automatically. ie

when the mail comes in. The other aspects of the rule work just not the

script.

When i run the rule manually, through the apply rule to existing mail tick

box everything works good.

Any ideas?

"Michael Bauer " wrote:



> Sorry, the first line should look like this:

> Public Sub Whatever(Mail as Outlook.MailItem)

> > Best regards
> Michael Bauer
> Category Manager -

> SAM - The Sending Account Manager:
>

> Am Mon, 5 Apr 2010 17:41:02 -0700 schrieb primed:
>
> > Hi Michael,
> > It came up with a run error.
> > Any ideas?
> > Thanks
> > Primed
> > "Michael Bauer " wrote:
> >
> >
> >
> >> The script that can be run by a rule must look like this:
> >
> >> Public Sub Whatever(Mail as Outlook)
> >> Mail.Subject=Date & " " & Mail.Subject
> >> Mail.Save
> >> End Sub
> >
> >> > >> Best regards
> >> Michael Bauer
> >> Category Manager -

> >> SAM - The Sending Account Manager:
> >>

> >
> >
> >> Am Wed, 31 Mar 2010 22:47:01 -0700 schrieb primed:
> >
> >>> Hi,
> >>
> >>> How do i automatically add the date yy/mm/dd to the front of the subject
> >>> header of incoming mail? Would gather its something to do with create
> >> rules
> >>> then run script, but cant workout how to create a script.
> >>
> >>> Thanks
> >>> Primed
> >> .
> >>
> .
>
 
1) See the Format function.

2) I've never tried it, but AFAIK you can't rename an attached file, instead

you'd have first to rename the file, then attach it. For that you could

monitor AttachmentAdd function: If you detect a file has been attached, save

it as a file, remove it from the email, rename the file, and attach it

again.

Best regards

Michael Bauer

Am Tue, 6 Apr 2010 17:03:01 -0700 schrieb primed:


> Cheers, that works better.
> Can the date be reversed so its like this 100407

> Also can the files attached to the document be renamed to have the same

date
> before them.

> Thanks
> Primed

> "Michael Bauer " wrote:
>
>

>> Sorry, the first line should look like this:
>

>> Public Sub Whatever(Mail as Outlook.MailItem)
>

>> > > Best regards
> > Michael Bauer
> > Category Manager -

> > SAM - The Sending Account Manager:
> >

>
>
>> Am Mon, 5 Apr 2010 17:41:02 -0700 schrieb primed:
> >
> >> Hi Michael,
> >
>>> It came up with a run error.
> >> Any ideas?
> >
>>> Thanks
> >> Primed
> >
>>> "Michael Bauer " wrote:
> >
>>>
>>>
>>>> The script that can be run by a rule must look like this:
> >>
>>>> Public Sub Whatever(Mail as Outlook)
> >>> Mail.Subject=Date & " " & Mail.Subject
> >>> Mail.Save
> >>> End Sub
> >>
>>>> > >>> Best regards
> >>> Michael Bauer
> >>> Category Manager -

> >>> SAM - The Sending Account Manager:
> >>>

>>>
>>>
>>>> Am Wed, 31 Mar 2010 22:47:01 -0700 schrieb primed:
> >>
>>>>> Hi,
> >>>
>>>>> How do i automatically add the date yy/mm/dd to the front of the

subject
> >>>> header of incoming mail? Would gather its something to do with create
> >>> rules
> >>>> then run script, but cant workout how to create a script.
> >>>
>>>>> Thanks
> >>>> Primed
> >>> .
> >>>
> > .
> >
 
Maybe there's another rule working on the received message for that you have

set the "don't execute more rules" action?

Best regards

Michael Bauer

Am Tue, 6 Apr 2010 18:01:01 -0700 schrieb primed:


> The script doesnt run when the rule is initiated automatically. ie
> when the mail comes in. The other aspects of the rule work just not the
> script.

> When i run the rule manually, through the apply rule to existing mail tick
> box everything works good.

> Any ideas?

> "Michael Bauer " wrote:
>
>

>> Sorry, the first line should look like this:
>

>> Public Sub Whatever(Mail as Outlook.MailItem)
>

>> > > Best regards
> > Michael Bauer
> > Category Manager -

> > SAM - The Sending Account Manager:
> >

>
>
>> Am Mon, 5 Apr 2010 17:41:02 -0700 schrieb primed:
> >
> >> Hi Michael,
> >
>>> It came up with a run error.
> >> Any ideas?
> >
>>> Thanks
> >> Primed
> >
>>> "Michael Bauer " wrote:
> >
>>>
>>>
>>>> The script that can be run by a rule must look like this:
> >>
>>>> Public Sub Whatever(Mail as Outlook)
> >>> Mail.Subject=Date & " " & Mail.Subject
> >>> Mail.Save
> >>> End Sub
> >>
>>>> > >>> Best regards
> >>> Michael Bauer
> >>> Category Manager -

> >>> SAM - The Sending Account Manager:
> >>>

>>>
>>>
>>>> Am Wed, 31 Mar 2010 22:47:01 -0700 schrieb primed:
> >>
>>>>> Hi,
> >>>
>>>>> How do i automatically add the date yy/mm/dd to the front of the

subject
> >>>> header of incoming mail? Would gather its something to do with create
> >>> rules
> >>>> then run script, but cant workout how to create a script.
> >>>
>>>>> Thanks
> >>>> Primed
> >>> .
> >>>
> > .
> >
 
Hi Michael,

1) Looked there but it didnt seem to give me the answer i was after.

"Michael Bauer " wrote:



> 1) See the Format function.

> 2) I've never tried it, but AFAIK you can't rename an attached file, instead
> you'd have first to rename the file, then attach it. For that you could
> monitor AttachmentAdd function: If you detect a file has been attached, save
> it as a file, remove it from the email, rename the file, and attach it
> again.

> > Best regards
> Michael Bauer
> Category Manager -

> SAM - The Sending Account Manager:
>

> Am Tue, 6 Apr 2010 17:03:01 -0700 schrieb primed:
>
> > Cheers, that works better.
> > Can the date be reversed so its like this 100407
> > Also can the files attached to the document be renamed to have the same
> date
> > before them.
> > Thanks
> > Primed
> > "Michael Bauer " wrote:
> >
> >
> >> Sorry, the first line should look like this:
> >
> >> Public Sub Whatever(Mail as Outlook.MailItem)
> >
> >> > >> Best regards
> >> Michael Bauer
> >> Category Manager -

> >> SAM - The Sending Account Manager:
> >>

> >
> >
> >> Am Mon, 5 Apr 2010 17:41:02 -0700 schrieb primed:
> >
> >>> Hi Michael,
> >>
> >>> It came up with a run error.
> >>> Any ideas?
> >>
> >>> Thanks
> >>> Primed
> >>
> >>> "Michael Bauer " wrote:
> >>
> >>>
> >>>
> >>>> The script that can be run by a rule must look like this:
> >>>
> >>>> Public Sub Whatever(Mail as Outlook)
> >>>> Mail.Subject=Date & " " & Mail.Subject
> >>>> Mail.Save
> >>>> End Sub
> >>>
> >>>> > >>>> Best regards
> >>>> Michael Bauer
> >>>> Category Manager -

> >>>> SAM - The Sending Account Manager:
> >>>>

> >>>
> >>>
> >>>> Am Wed, 31 Mar 2010 22:47:01 -0700 schrieb primed:
> >>>
> >>>>> Hi,
> >>>>
> >>>>> How do i automatically add the date yy/mm/dd to the front of the
> subject
> >>>>> header of incoming mail? Would gather its something to do with create
> >>>> rules
> >>>>> then run script, but cant workout how to create a script.
> >>>>
> >>>>> Thanks
> >>>>> Primed
> >>>> .
> >>>
> >> .
> >>
> .
>
 
To that function you can pass the format you want, use YY for a two digit

year, YYYY for a four digit year, etc.

Best regards

Michael Bauer

Am Wed, 7 Apr 2010 17:13:01 -0700 schrieb primed:


> Hi Michael,

> 1) Looked there but it didnt seem to give me the answer i was after.

> "Michael Bauer " wrote:
>
>

>
>> 1) See the Format function.
>

>> 2) I've never tried it, but AFAIK you can't rename an attached file,

instead
> > you'd have first to rename the file, then attach it. For that you could
> > monitor AttachmentAdd function: If you detect a file has been attached,

save
> > it as a file, remove it from the email, rename the file, and attach it
> > again.
>

>> > > Best regards
> > Michael Bauer
> > Category Manager -

> > SAM - The Sending Account Manager:
> >

>
>
>> Am Tue, 6 Apr 2010 17:03:01 -0700 schrieb primed:
> >
> >> Cheers, that works better.
> >> Can the date be reversed so its like this 100407
> >
>>
>>> Also can the files attached to the document be renamed to have the same
> > date
> >> before them.
> >
>>> Thanks
> >> Primed
> >
>>> "Michael Bauer " wrote:
> >
>>>
>>>> Sorry, the first line should look like this:
> >>
>>>> Public Sub Whatever(Mail as Outlook.MailItem)
> >>
>>>> > >>> Best regards
> >>> Michael Bauer
> >>> Category Manager -

> >>> SAM - The Sending Account Manager:
> >>>

>>>
>>>
>>>> Am Mon, 5 Apr 2010 17:41:02 -0700 schrieb primed:
> >>
>>>>> Hi Michael,
> >>>
>>>>> It came up with a run error.
> >>>> Any ideas?
> >>>
>>>>> Thanks
> >>>> Primed
> >>>
>>>>> "Michael Bauer " wrote:
> >>>
>>>>>
>>>>>
>>>>>> The script that can be run by a rule must look like this:
> >>>>
>>>>>> Public Sub Whatever(Mail as Outlook)
> >>>>> Mail.Subject=Date & " " & Mail.Subject
> >>>>> Mail.Save
> >>>>> End Sub
> >>>>
>>>>>> > >>>>> Best regards
> >>>>> Michael Bauer
> >>>>> Category Manager -

> >>>>> SAM - The Sending Account Manager:
> >>>>>

>>>>>
>>>>>
>>>>>> Am Wed, 31 Mar 2010 22:47:01 -0700 schrieb primed:
> >>>>
>>>>>>> Hi,
> >>>>>
>>>>>>> How do i automatically add the date yy/mm/dd to the front of the
> > subject
> >>>>>> header of incoming mail? Would gather its something to do with

create
> >>>>> rules
> >>>>>> then run script, but cant workout how to create a script.
> >>>>>
>>>>>>> Thanks
> >>>>>> Primed
> >>>>> .
> >>>>
>>>> .
> >>>
> > .
> >
 
Hi

i've never created a script before and hope i have done it correctly

i opened Tool>Macro>Visual Basic Editor

inserted a new module

copied in

Public Sub Whatever(Mail As Outlook.MailItem)

Mail.Subject = Date & " " & Mail.Subject

Mail.Save

End Sub

and saved

then in Tools>Rules and Alerts and created a new rule

Apply this rule after the message arrives

on this machine only

run Project1.Whatever

i ran it on my inbox an sent myself an email and nothing happens

im on office outlook 2003 SP2

many thanks

Darren

DarrenD
 
Does it make a difference if you move the code from the module to

ThisOutlookSession? (Don't forget to edit the rule, too.)

If not, set a breakpoint (f9) on the first line of code. Does the code

execution stopps there when a new message arrives?

Best regards

Michael Bauer

Am Fri, 7 May 2010 10:47:41 +0100 schrieb DarrenD:


> Hi

> i've never created a script before and hope i have done it correctly

> i opened Tool>Macro>Visual Basic Editor
> inserted a new module
> copied in

> Public Sub Whatever(Mail As Outlook.MailItem)
> Mail.Subject = Date & " " & Mail.Subject
> Mail.Save
> End Sub

> and saved

> then in Tools>Rules and Alerts and created a new rule

> Apply this rule after the message arrives
> on this machine only
> run Project1.Whatever

> i ran it on my inbox an sent myself an email and nothing happens

> im on office outlook 2003 SP2

> many thanks
> Darren
 
I have copied it to the ThisOutlookSession and created a new rule to

pick it up

i set the breakpoint on the line

Mail.Subject = Date & " " & Mail.Subject

sent a couple of emails to the account and they still got delivered

without any date in the subject bar

'Michael Bauer [MVP - Outlook Wrote:
> ;348674']Does it make a difference if you move the code from the module
> to
> ThisOutlookSession? (Don't forget to edit the rule, too.)

> If not, set a breakpoint (f9) on the first line of code. Does the code
> execution stopps there when a new message arrives?

> > Best regards
> Michael Bauer
> Category Manager -

> SAM - The Sending Account Manager:
> http://www.vboffice.net/product.html?lang=en

> Am Fri, 7 May 2010 10:47:41 +0100 schrieb DarrenD:
> -
> Hi

> i've never created a script before and hope i have done it correctly

> i opened ToolMacroVisual Basic Editor
> inserted a new module
> copied in

> Public Sub Whatever(Mail As Outlook.MailItem)
> Mail.Subject = Date & " " & Mail.Subject
> Mail.Save
> End Sub

> and saved

> then in ToolsRules and Alerts and created a new rule

> Apply this rule after the message arrives
> on this machine only
> run Project1.Whatever

> i ran it on my inbox an sent myself an email and nothing happens

> im on office outlook 2003 SP2

> many thanks
> Darren-

DarrenD
 
So the code execution doesn't stop there? Then check Tools/Macros/Security,

whether VBA is executed at all.

Best regards

Michael Bauer

Am Fri, 14 May 2010 16:42:29 +0100 schrieb DarrenD:


> I have copied it to the ThisOutlookSession and created a new rule to
> pick it up

> i set the breakpoint on the line
> Mail.Subject = Date & " " & Mail.Subject

> sent a couple of emails to the account and they still got delivered
> without any date in the subject bar

> 'Michael Bauer [MVP - Outlook Wrote:
> > ;348674']Does it make a difference if you move the code from the module
> > to
> > ThisOutlookSession? (Don't forget to edit the rule, too.)
>

>> If not, set a breakpoint (f9) on the first line of code. Does the code
> > execution stopps there when a new message arrives?
>

>> > > Best regards
> > Michael Bauer
> > Category Manager -

> > SAM - The Sending Account Manager:
> > http://www.vboffice.net/product.html?lang=en
>

>
>
>> Am Fri, 7 May 2010 10:47:41 +0100 schrieb DarrenD:
> > -
> > Hi
>

>> i've never created a script before and hope i have done it correctly
>

>> i opened ToolMacroVisual Basic Editor
> > inserted a new module
> > copied in
>

>> Public Sub Whatever(Mail As Outlook.MailItem)
> > Mail.Subject = Date & " " & Mail.Subject
> > Mail.Save
> > End Sub
>

>> and saved
>

>> then in ToolsRules and Alerts and created a new rule
>

>> Apply this rule after the message arrives
> > on this machine only
> > run Project1.Whatever
>

>> i ran it on my inbox an sent myself an email and nothing happens
>

>> im on office outlook 2003 SP2
>

>> many thanks
> > Darren-
 
Status
Not open for further replies.
< Creating and sanding tasks from Access VBA | compile error on previously functioning code outlook 2003 windows >
Similar threads
Thread starter Title Forum Replies Date
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 17
D Add date next to day name in Outlook Today calendar view Using Outlook 1
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
A Email Macro to add Date and Classification Outlook VBA and Custom Forms 2
C add a date without holidays Outlook VBA and Custom Forms 2
0 Add a date stamp to the note field of a custom form Outlook VBA and Custom Forms 1
T Add Account Using Outlook 1
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
G Outlook 2021 Add Picture to Custom Contact Form Outlook VBA and Custom Forms 2
P Can't add custom field to custom Outlook form, it always adds to the Folder instead Outlook VBA and Custom Forms 2
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
G automatically choosing "add to autocorrect" option Using Outlook 0
F Want to add second email to Outlook for business use Using Outlook 4
K Add an entry to a specific calendar Using Outlook 1
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
J Want to create a button on the nav bar (module add-in) to run code Outlook VBA and Custom Forms 2
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
J Outlook 365 Add keywords from Listbox to the message body where cursor is placed Outlook VBA and Custom Forms 0
O Add Day Number of the year for 2023-2033 Outlook VBA and Custom Forms 5
J GoDaddy migrated to Office365 - Outlook Wont Add Account Exchange Server Administration 21
F Outlook 2019 Outlook 2019 Add and Sync to New computer Comcast server Using Outlook 2
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
A iCloud Outlook Add In is causing Outlook 2021 to crash and got disabled Using Outlook 10
N How to add or delete items to Move dropdown Menu Using Outlook 0
G Add contacts birthday to calendar Using Outlook 4
V How to add 'Previous Item' and 'Next Item' to the Quick Access Toolbar Using Outlook 1
Commodore Safe way to add or update holidays; Windows Notifications issue Using Outlook 8
kkqq1122 How would I add Search for attachment name Outlook VBA and Custom Forms 3
L did MS ever add way to text via Outlook Using Outlook 5
P How to add a column named categories when searching in Outlook Using Outlook 0
M add new attendee to existing meetings with VBA Outlook VBA and Custom Forms 5
N Can't create NEW GROUP and add/remove a member from existing Group in Outlook Using Outlook 1
Witzker Outlook 2019 Pls. add a Prefix for OUTLOOK 2019 here Using Outlook 1
P Add inanimate objects to meetings? Using Outlook 1
O Outlook 2010 Add delete button to the side of the message list Using Outlook 1
BartH Add a string to the conditions in .Conditions.BodyOrSubject.Text Outlook VBA and Custom Forms 2
A "Get Add-Ins" - Which Version of Outlook to use Using Outlook 1
D Do I need Exchange Add-In? Using Outlook 6
C-S-R Manage Add-ins (Remove Wunderlist) Using Outlook 6
A iCloud add in problems Using Outlook 4
C Looking for feedback on new Outlook Add-in Using Outlook 0
L isn't there an OL add-on that flags addressee before sending Using Outlook 3
S Add VBA save code Using Outlook 0
P Shortcut Pane - add shortcut to Office365 group mailbox Using Outlook 1
Z Add ComboBox Value to Body of Email Outlook VBA and Custom Forms 1
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 6
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
M Automatically add senders first name to a greeting Outlook VBA and Custom Forms 1

Similar threads

Back
Top