?
Solved

Custom Form macro popups-AARGH

Posted on 2002-07-11
5
Medium Priority
?
319 Views
Last Modified: 2012-06-27
Need help trying to remove Macro warning popups.

I have created a custom form in outlook 2000 and this connects to an access database via use of vbScipt.

Now i have placed this in the companys organisational forms library and will be sending out a mail shortly to get all staff to fill it in.

These will get send to my inbox and from the read form i can click export to export all these to access.

What i dont want - is to click "enable macros" which will appear for every entry that is submitted.

I have tried a few things - placed the form in organisational forms library (as above), Set the macro security to low with still no luck.

any help please? or indeed if you require additional information please reply.  urgently needs fixing.

thanks.
0
Comment
Question by:joe_lafferty
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 16

Expert Comment

by:Neo_mvps
ID: 7145717
Sounds like something has caused the form to one-off.  A good jump off point that has suggestions/links that covers this topic is http://www.slipstick.com/dev/formpub.htm#macro
0
 
LVL 8

Expert Comment

by:jessnjeff
ID: 7157767
If it is a revision of an older form, sometimes the forms cache gets 'confused'.  I have found that most of the problems similar to yours are fixed by deleting the files in the forms cache, then reopening the form.  You should try clearing.
0
 

Author Comment

by:joe_lafferty
ID: 7158934
The form im desigining is a revision of the actual mail form that outlook has as default.

When the users click send this gets redirected to a personal folder of mine, and from there i click a custom button to send to access. So the actual macro is been activated from within this form on the pesonal folder.  I believe that because its this location outlook does'nt recognise this as been a trusted area and therefore prompts the macro security message.

My export to access will submit all messages in this folder and therefore a macro for each one.

I hope i have clarified this somewhat.

thanks.
0
 
LVL 8

Accepted Solution

by:
jessnjeff earned 400 total points
ID: 7160258
You cannot get around the warning unless you publish in the Organizational Folders.  Perhaps you can if you publish the revision to each user's personal folder, but I have never tried that.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7347184
Hello joe_lafferty

this question is open for more then 2 months
time to clean up
if not stated otherwise

my recom will be
-PAQ
-points to jessnjeff
-this will be finalized by an EE Moderator
-with no further update (26.10.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
posted by ToolzEE v1.0
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
Mailbox Overload?
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question