emails / sms but not as attatchment as answer to query

#1 (**permalink**) 28-Jul-2006, 08:11 AM

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.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10276-emails-sms-but-not-attatchment-answer.html
i'm relativley new to acess - so the simplist instructions would be great

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10276

#2 (**permalink**) 28-Jul-2006, 08:11 AM

As far as the actual sending, look up sendobject.

No object needs to be sent, and you can construct the message text to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10276
be the above or even the title can be that.