A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook macros have vanished



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old April 7th 09, 05:01 PM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
 
Posts: 1
Default Outlook macros have vanished

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
Ads
  #2  
Old April 7th 09, 09:04 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Outlook macros have vanished



That's a script that can be called by a rule; you won't find it under
tools/macro.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Tue, 7 Apr 2009 09:01:56 -0700 (PDT) schrieb :

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

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
contents have vanished Ellie P Outlook Express 3 October 15th 08 10:47 PM
clock vanished! Sheila[_2_] Outlook Express 2 August 21st 07 02:18 PM
magically vanished emails Sarah Outlook Express 1 August 13th 07 10:08 PM
Items Vanished Aaron-McLeod Outlook - General Queries 2 October 11th 06 01:33 AM
Bizzare problem - emails vanished in Outlook 2003 Cyberbub Outlook - General Queries 0 August 7th 06 09:24 AM


All times are GMT +1. The time now is 02:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.