links other applications

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

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

Links to other applications

resolvedResolved · Low Priority · Version 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:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips


Server loaded in 0.08 secs.