links other applications
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Thu 4 Sep 2008, 15:58Delegate Paul said...

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.

For upcoming training course dates see: Pricing & availability

replyReply Wed 17 Sep 2008, 12:41Trainer Laura said...

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

replyReply Wed 17 Sep 2008, 23:31Delegate Paul said...

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

 

Please browse our web site to find out more about
microsoft.access.courses and other Microsoft training courses.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard