C
chriswg
Hi
About 6 months ago I set up a Macro in Outlook 2003 as follows:
Sub ReplyWithTemplate(Item As Outlook.MailItem)
Dim olkReply As Outlook.MailItem, _
olkTemplate As Outlook.MailItem
Set olkReply = Item.reply
Set olkTemplate = Application.CreateItemFromTemplate("C:\Documents and
Settings\Chris\Application Data\Microsoft\Templates\Feedback.oft")
olkTemplate.Recipients.Add olkReply.Recipients.Item(1).Address
olkTemplate.Recipients.ResolveAll
olkTemplate.Send
Set olkReply = Nothing
Set olkTemplate = Nothing
End Sub
All I wanted to do was to be able to send a standard email back to
every candidate that sent me their CV.
This worked fine for a few days and then I stopped using it as we
weren't so busy. Last week I have tried to turn the Outlook rule back
on and the Macro has vanished. Worse than that, when I open VBA Editor
re-create the Macro it just said No Projects and everything was greyed
out.
I had been holding out on upgrading to Office 2007 for a while but I
decided this was finally the best time so this morning my package
arrived and I went through the upgrade procedure. Unfortunately, its
still the same problem, although I can now get a Project 1 tree of
Project1 (Vbaproject.OTM) / Microsoft Office Outlook Objects /
ThisOutlookSession. I can even 'Insert' a Module1 but after pasting in
the macro above, saving, then returning to Outlook I click Tools/Macro/
Macros and the list is blank.
Any help would be very much appreciated, I have spent most of today
digging around websites trying to find the answers but so far nothing.
I know the VBA Addin is enabled, and I know the Macro security is set
to Medium/Low so those aren't the culprits. Also, I put the code on a
friends machine too and his has stopped running now too.
Many thanks
Chris
About 6 months ago I set up a Macro in Outlook 2003 as follows:
Sub ReplyWithTemplate(Item As Outlook.MailItem)
Dim olkReply As Outlook.MailItem, _
olkTemplate As Outlook.MailItem
Set olkReply = Item.reply
Set olkTemplate = Application.CreateItemFromTemplate("C:\Documents and
Settings\Chris\Application Data\Microsoft\Templates\Feedback.oft")
olkTemplate.Recipients.Add olkReply.Recipients.Item(1).Address
olkTemplate.Recipients.ResolveAll
olkTemplate.Send
Set olkReply = Nothing
Set olkTemplate = Nothing
End Sub
All I wanted to do was to be able to send a standard email back to
every candidate that sent me their CV.
This worked fine for a few days and then I stopped using it as we
weren't so busy. Last week I have tried to turn the Outlook rule back
on and the Macro has vanished. Worse than that, when I open VBA Editor
re-create the Macro it just said No Projects and everything was greyed
out.
I had been holding out on upgrading to Office 2007 for a while but I
decided this was finally the best time so this morning my package
arrived and I went through the upgrade procedure. Unfortunately, its
still the same problem, although I can now get a Project 1 tree of
Project1 (Vbaproject.OTM) / Microsoft Office Outlook Objects /
ThisOutlookSession. I can even 'Insert' a Module1 but after pasting in
the macro above, saving, then returning to Outlook I click Tools/Macro/
Macros and the list is blank.
Any help would be very much appreciated, I have spent most of today
digging around websites trying to find the answers but so far nothing.
I know the VBA Addin is enabled, and I know the Macro security is set
to Medium/Low so those aren't the culprits. Also, I put the code on a
friends machine too and his has stopped running now too.
Many thanks
Chris