Send SMS from Access 2000 to multiple recipients with Excel output attached

I need to be able to send an end of day file from Access 2000 to my clients iphone. It needs to be Excel output based on a query. I need to be able to send to multiple people at once and trigger with a timer. Thanks!
gaynesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TomDromiCommented:
for how meny clients? do you have free network service to do the SMS sending?

The general way is:
1. make other access file that link to your main DB. you can make the other file in version 2007.
2. in that new file create an auto/autoexec macro that lunch when the file opens.
3. create a task with the task Scheduler (from the control panel \ administration option) that open this file or with other Scheduler.
3. this macro need to run report that make the excel output (this is one of the output options).
4. the next step depend on your SMS gateway: some of them will require you to write code to communicate with them and some will wait for mail. (might some of the option better to connect with directly from access.

comment for more assistance.

Tom
0
gaynesAuthor Commented:
Tom - I already knew the first 3. I don't know how to make Access send an SMS message. I don't think they have a SMS gateway unless that is part of exchange.
0
TomDromiCommented:
for how many clients do you need that?
Tom
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

gaynesAuthor Commented:
1
0
TomDromiCommented:
I mean how many SMS you want to send for a day and do you (they) want to put money for this solution or are you looking for a free solution?
0
TomDromiCommented:
http://www.clickatell.com/developers/scripts.php - this is the largest company on the market. It will cost you few cents for SMS (depend on your location).

if you need just few SMS for day and you have budget limit you can use ICQ or messanger or Gmail SMS. also, many of the cellular company have dedicated SMS gateway that you cand send it mail like:
052123456789@orange.co.uk or something like that and it is depend on your network.

Tom
0
gaynesAuthor Commented:
I am not sure you can even send a spreadsheet attachment with a text?
0
TomDromiCommented:
so why not to publish it to web page? access know how to do that too. it can be your publish location of the report. then you can send them a mail or an sms to see the updated report.

Tom
0
LadyHagoodCommented:
just stumbled acrross this thread, can a standard message be sent to any phone number not just an iphone from access 2003?
0
gaynesAuthor Commented:
I did figure out that you can do it using this
http://www.makeuseof.com/tag/email-to-sms/
Just send an email and it becomes an SMS. I am pretty sure you can't send attachments except MMS type.
0
TomDromiCommented:
yes, this is the easy way to send few SMSs a day (most of these services are limited to about 20 messages a day).

why not to send a sms with link  to a web page with your SpreadSheet?
with Iphone they will be able to open it.

How big is your sheet? SMS message can be about 140 chrarecters for a message and you can send few messages together.

Tom
0
gaynesAuthor Commented:
Then I have to worry about uploading the spreadsheet every night.
0
TomDromiCommented:
I think this will give you the way:
http://office.microsoft.com/en-us/access/HP052612171033.aspx

Tom
0
gaynesAuthor Commented:
this is apparently not possible
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.