Send mail - exchange servver

  • Thread starter Thread starter jwallac
  • Start date Start date
J

jwallac

Hi,

I have a form with a combo box. I want to send a mail automatically
when this combo box is updated. I know I can use docmd.sendmail or
sentobject to automatically send this mail, however the table was
created long before we installed exchange server. I am unsure how to
reconcile the user in the table with the exchange server user. All
clients use Outlook. Is there any examples where i can see how this is
implemented.

Justin
 
I have a similar question Arvin, I have a command button that sends the
email to Me.ContactName. I do not want the command button, instead i
want to automate that to every week. In other words, i want to
automatically send weekly emails to all records in the field name
ContactName in the table SystemInfo and i also want to set a flag such
as, send email to all ContactNames in table SystemInfo until AT-Score
is not null else exclude that ContactName.

Is it Possible?

Your help or suggestions would be greatly appreciated.

Thanks
Moe
 
You can always use Windows scheduler directly to schedule tasks.
Alternatively, you can try our macro program, Workspace Macro Pro. You
can get more information and free trial download from
http://www.tethyssolutions.com/macro-automation.htm

It would make things easier for you.

We also have more advanced Automation Software, Automation Anywhere.
That offers ability to read databases and send emails etc, but looking
at Arvin's script you may not need that.

Tethys Solutions, Expert Services Group
http://www.tethyssolutions.com/ask-the-expert.htm
SMART Macro & Automation Solutions
 
Ok Windows Scheduler does make sense, i can have the windows scheduler
run the database but only one issue with that, when the database opens
up,is there any way the email codes on your website automatically
trigger, i mean the module runs automatically on running or openning
the database??

If i need a line or two line of code to be added and if you can help me
out please let me know, i would be much obliged.

Thanks

Moe
 
Back
Top