Outlook macros have vanished

  • Thread starter chriswg@gmail.com
  • Start date
Status
Not open for further replies.
C

chriswg@gmail.com

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
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
That's a script that can be called by a rule; you won't find it under

tools/macro.

Best regards

Michael Bauer

Am Tue, 7 Apr 2009 09:01:56 -0700 (PDT) schrieb chriswg@gmail.com:


> 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
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
J Want to learn VBA Macros for Outlook. What book can you recommend? Outlook VBA and Custom Forms 2
D Outlook macros to create meeting on shared calendar Outlook VBA and Custom Forms 10
Diane Poremsky Using Arrays in Outlook macros Using Outlook 0
Diane Poremsky Running Outlook Macros on a Schedule Using Outlook 0
S Using Macros in the Outlook Calendar Using Outlook 2
A Outlook 2010 disabled macros Using Outlook 2
R Outlook Macros for Appointments and Tasks Using Outlook 1
L Macros disabled in custom Outlook form Outlook VBA and Custom Forms 1
M macros of outlook 2007 Outlook VBA and Custom Forms 1
C Create macros in Outlook 2007 Outlook VBA and Custom Forms 5
S Need: Date handling in Outlook Macros, either information/documentation Outlook VBA and Custom Forms 1
N Copying outlook macros between pcs Outlook VBA and Custom Forms 1
D Macros Disabled in Outlook 2007 BCM (Business Contact Manager) 9
Horsepower Cannot delete gmail in iPhone Outlook outbox Using Outlook 0
F Outlook 2019 Outlook 2019 Add and Sync to New computer Comcast server Using Outlook 2
M Understanding Outlook Identities Using Outlook 1
kburrows Outlook or Phone Combining Contacts? Using Outlook 0
P Outlook 2013 search no longer works Using Outlook 0
M Accessing ALL Outlook contact fields Outlook VBA and Custom Forms 1
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 0
R MailTips and older Outlook versions Using Outlook 0
A iCloud Outlook Add In is causing Outlook 2021 to crash and got disabled Using Outlook 4
C How to import Outlook calendar? Using Outlook 0
HarvMan Outlook 365 loses "outlook.com" exchange server settings Using Outlook 1
HarvMan Outlook.com Account Using Outlook 3
D Office 365 Outlook desktop app prompts for all account passwords on startup Using Outlook 5
D Alerts in outlook Using Outlook 1
richardwing Auto forward email that is moves into a specific outlook folder Outlook VBA and Custom Forms 5
L Recommendations for Utility to Backup Outlook 365 Account Settings Using Outlook 2
J Recommendations for Outlook Duplicate Email Remover Using Outlook 6
O Outlook - How to embed font ? (If at all possible) Using Outlook 2
Z New minimum Outlook for Windows version requirements for Microsoft 365/Exchange Online Using Outlook.com accounts in Outlook 16
T How to configure Outlook for two users on a single Windows account Using Outlook 3
R Outlook 2021 Having problem setting up outlook 2021 with windows 11. I have 3 gmail accounts and I want the 3 gmail, emails to merge into the same outlook input. Using Outlook.com accounts in Outlook 0
e_a_g_l_e_p_i Outlook 2021 all appointments not showing in calendar Using Outlook 2
S Outlook 365 Can I change the possible range of highlighting colours when writing an Outlook email? Using Outlook 1
B Outlook 213 keeps crashing. I just found out there are DMP files. How can I tell Why? Using Outlook 2
H Outlook 2016 related mails in outlook Outlook VBA and Custom Forms 13
S Outlook 2021 Can you make emails from 3 word domains "safe" by entering top 2 word domain into Safe List in Outlook? Using Outlook 1
@ Outlook Using Outlook 2
kburrows Outlook 365 - Ribbon Customizations Disappear Using Outlook 0
D Wishlist How to use 'app password' in Outlook 2003 after Google pulled plug on "less secure apps" Using Outlook 2
L Restoring Outlook from backup pst file Using Outlook 5
e_a_g_l_e_p_i Kernel Outlook .pst viewer Using Outlook 3
L Outlook 365 Outlook not working on linux how to solve it Using Outlook.com accounts in Outlook 0
T Outlook 2019 Using Gmail aliases in Outlook Using Outlook 6
S Activities in Outlook Outlook VBA and Custom Forms 3
S ios outlook Using Outlook.com accounts in Outlook 0
W Transfer Outlook 2016 autocomplete file to Outlook 2007 Using Outlook 1
V iCloud calendar problems, Outlook shuts down immediately Using Outlook 2

Similar threads

Top