VBScript to replace module?

Status
Not open for further replies.

EdNerd

Member
Outlook version
Outlook 2007
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
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
 

EdNerd

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
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
 

EdNerd

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
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.
Similar threads
Thread starter Title Forum Replies Date
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
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 New Slipstick.com Articles 0
B Delete/replace old files and save new attachments Using Outlook 1
Diane Poremsky Replace Display Names with Email Addresses New Slipstick.com Articles 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
W Turn off "Replace text as you type" in Outlook 2010 Using Outlook 2
J outlook will not open, uploaded new 2010 to replace beta version and everything but outlook works. ____ Using Outlook 4
S Replace default calendar 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
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
R Addins4Outlook TagIt! addin script or VBA module? Using Outlook 2
L Script to Macro in Module Using Outlook 36
S Exam 77-884: Managing Contact Module Options Using Outlook 4
L Can't find procedure or module to run Outlook VBA and Custom Forms 4

Similar threads

Top