VBScript to replace module?

Status
Not open for further replies.
E

EdNerd

Member
Outlook version
Email Account
Exchange Server
I am trying to implement my first Outlook "program". I've been doing this

with Word and Excel add-ins for years, but this is my first for OL.

First, I have to be able to work within the contraints of my company's

security policies. In the Trust Center, all options for Programmatic Access are

deselected and greyed out. Macro Security is likewise permanently set to

Wanrings for all macros. I have no trusted Publishers and am not allowed to add

any. I can manage add-ins, but I do not have (that I know of) any way to create

a DLL file as a COM add-in, nor can I install a program that would help me

create one.

From what I understand, that leaves me with using BAS module files. I'm okay

with that. I will have maybe 15-20 users to distribute these to, and I can't

count on any of them to understand anything about the VB Editor. Then again,

some of them might surprise me and have macros of their own - but I doubt

it.

I could issue instructions like:

-- Open Outlook and hit ALT+F11

-- Expand VbaProject.OTM, then expand Modules

-- Delete SaveMyEmailAttach

-- File >> Import File >> navigate to SaveMyEmailAttach and click Open

I'd prefer to get as much of that into a script as possible - if it is at all

in any way possible! Or find a much easier way altogether.

I'd love to hear anyone's thoughts.

Ed
 
If no one has macros, the easiest way is to drop it in the folder as an OTM. I'd ask if anyone is using macros and if not, use a logon script to drop it in the folder. I don't think the file is created until they open the VBE, so you could check for the presence of the OTM before copying it.
 
Hi, Diane. Thanks for chiming in. I don't grasp the concepts of what you said, though.




-- "Drop it": the BAS file?


-- "the folder": what folder?


-- "as an OTM": what's an OTM?




Sorry to be so dense. If you could help me learn this, I'd be most grateful.




Ed
 
Okay - never mind. A little bit of research and I found info about replacing the VbaProject.OTM file. That really looks like the best way to go for me, as long as no one else is using macros in Outlook.

Thanks for the boost!

Ed
 
Status
Not open for further replies.
< VBA Macro to flag sent emails | Outlook file folder disappeared >
Similar threads
Thread starter Title Forum Replies Date
A VBscript stops running after updating form Outlook VBA and Custom Forms 1
B VBScript doesn't run on Recipient Email Outlook VBA and Custom Forms 2
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
M Forward Appointment as BCC with VBScript Outlook VBA and Custom Forms 7
D Security patch seems to kill vbscript on Enterprise Level Outlook VBA and Custom Forms 4
R VBScript Commands Outlook VBA and Custom Forms 2
Mark White VBScript Move sent mail to non-default folder Outlook VBA and Custom Forms 5
Mark White VBScript Move sent mail to non-default folder Outlook VBA and Custom Forms 0
S my vbscript button1_click code works on appointment created but not on opening an existing apntmn Outlook VBA and Custom Forms 16
JorgeDario Template oft that contains VBScript Is not running Using Outlook 1
J Outlook 2010 VBScript editor does not run code at all Outlook VBA and Custom Forms 0
T Create new item in public folder using VBscript Outlook VBA and Custom Forms 1
R VBScript Sendmail not selecting correct 'from' address Outlook VBA and Custom Forms 3
B Recommended Outlook & VBScript Books? Outlook VBA and Custom Forms 3
Mary B VBscript: Need to copy every email to a folder & mark that copy as read Outlook VBA and Custom Forms 5
K VBScript Outlook, add attachment Outlook VBA and Custom Forms 1
S VBA Macro to VBScript Outlook VBA and Custom Forms 1
F VBScript to add pre defined text Using Outlook 5
D Custom form and VBScript Using Outlook 5
F VBScript copy contacts and remove duplicates Using Outlook 1
R VBA Macro to VBScript in a form- Help Please! Using Outlook 10
H Accessing a control on a frame in Outlook with VBScript Outlook VBA and Custom Forms 1
Y Creating a Task with VBScript Outlook VBA and Custom Forms 14
N VBScript does not run in Outlook 2003 Outlook VBA and Custom Forms 4
T Replace Text in Email Subject Outlook VBA and Custom Forms 3
O Replace hard returns with soft returns on selected text and button to QAT Using Outlook 5
Beeto Replace a string in body Outlook VBA and Custom Forms 2
O How to find and replace a word in Outlook-Agenda-Subject and Message? Using Outlook 0
S HTML Code Embedded in String Within Open Outlook Email Preventing Replace(Application.ActiveInspector.CurrentItem.HTMLBody From Working Outlook VBA and Custom Forms 4
M Outlook 2013 Replace Subject with Conversation (a "hidden" value). Outlook VBA and Custom Forms 0
F Copy and replace not update contact in another pst Using Outlook 0
B Automatically Forward Emails and Remove/Replace All or Part of Body Outlook VBA and Custom Forms 8
C How to replace or delete first instance of sentence in mail body? Outlook VBA and Custom Forms 1
C replace subject line generated by converting a word document to PDF and sending it to an email Using Outlook 8
Diane Poremsky How to perform a global search and replace Using Outlook 0
B Delete/replace old files and save new attachments Using Outlook 1
Diane Poremsky Replace Display Names with Email Addresses Using Outlook 0
mrje1 Is there a Find and Replace feature in Outlook 2016? Using Outlook 4
J Pull an email address from body and replace reply-to address Outlook VBA and Custom Forms 4
divan Outlook 2007 - Replace email body with custom text Using Outlook 9
A How to replace column title in address book Using Outlook 1
V Replace only part of subject in OUTLOOK 2003 Outlook VBA and Custom Forms 1
A Replace olFolderContacts for Sharepoint lists in Outlook Outlook VBA and Custom Forms 5
P replace default outlook form with custom form Outlook VBA and Custom Forms 1
A How to replace getcontactsfolder (ol2007) in Outlook 2003 Outlook VBA and Custom Forms 2
J Is the Windows Outlook Tasks module really going to be gone? Using Outlook 6
petunia Outlook tasks module sunsetting? Exchange Server Administration 3
J Want to create a button on the nav bar (module add-in) to run code Outlook VBA and Custom Forms 2
A Calling one module from another Outlook VBA and Custom Forms 2
230Grains iCloud COM Module Keeps de-selecting in Outlook 2013 Using Outlook 1

Similar threads

Back
Top