email all

  • Thread starter Thread starter k
  • Start date Start date
K

k

hi, i have set up the sample to email multiple
receiptents.all works fine, and the emails go through.
2 questions? How do i run the module code from my form by
pushing a command butt. at the moment i'm running it from
the VB Editor.
2.) when the message is sent i get a box telling me
outlook is sending do i want to send? and i have push yes
every time for each email address to send to..this will
take ages.is this normal ? thks
 
k said:
hi, i have set up the sample to email multiple
receiptents.all works fine, and the emails go through.
2 questions? How do i run the module code from my form by
pushing a command butt. at the moment i'm running it from
the VB Editor.
2.) when the message is sent i get a box telling me
outlook is sending do i want to send? and i have push yes
every time for each email address to send to..this will
take ages.is this normal ? thks
Click to expand...


1) You will have to call the function. I usually create a macro with
the RunCode method and call it from the command button. You should
also be able to do a function call from the OnClick event.

2) Microsoft calls this a "feature", but it's actually just a huge pain
in the neck. Basically, Access is tapping into Outlook and the
built-in security settings force you to approve each communication
between them. You can try checking the box to "Allow access for..."
and set a time, although it is my experience that this changes nothing.
I have also heard tell of methods to disable this feature at the server
level:

<http://support.microsoft.com/default.aspx?scid=kb;EN-US;290499>
<http://www.outlookcode.com/d/ol2002problems.htm>

We have not yet tried anything, mostly because we have other problems.


Hope this helps,
Matt
 
Back
Top