Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

links other applications

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Links to other applications

Links to other applications

ResolvedVersion 2003

Paul has attended:
Access VBA course

Links to other applications

I have code sending automated messages through Outlook. Every time it sends one Outlok brings up a security warning. Is there any way of either forcing the warning to process "Yes" or warning if it hasn't been done.

RE: links to other applications

The security question was put in to prevent the viruses that spread through emails being sent without your knowledge. So microsoft have not included a method to avoid the question. Due to the fact that there is a high demand for avoidance of the question there are various products out there that do what you want.

I have never used one and so I would not like to recommend one. I would stress though that you don't leave such a product running all the time as the virus risk is there. There is also every chance that your employer will say no as it will breach their security protocols.

Is there any way of batching your emails to be sent all at the same time? Therefore only ask the question once.

Laura GB

RE: links to other applications

Thanks very much Laura,
I sort of expected that there wouldn't be a code write round for the reason you stated but it doesn't hurt to ask.
As the e-mails create a workflow based prompt for collection of funds with a customer, it isn't desirable to batch them as this would slow the workflow down.

Kind Regards
Paul

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.