emails / sms but not as attatchment as answer to query

[Guest]

HI

i wish to send sms messages from access, either as a email to a gateway
providor who will convert it to text (sms) or another way if there is one.

but the main thing is that i dont want it is an an attatchement but as the
answer from a query/form - i.e how many orrders have been processed. which
could be anything from 1 to 500. i want the system to send the mail either
every coulple of hors or at a set time. all it needs is the address and a
line of text saying " total ordered processed = XXX" where xxx is the result
from the query.

i'm relativley new to acess - so the simplist instructions would be great

 

[Ron2006]

As far as the actual sending, look up sendobject.

No object needs to be sent, and you can construct the message text to
be the above or even the title can be that.

 

[Ron2006]

As far as the actual sending, look up sendobject.

No object needs to be sent, and you can construct the message text to
be the above or even the title can be that.