[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2010-04-01
14
Medium Priority
?
573 Views
Last Modified: 2013-11-27
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!
0
Comment
Question by:gaynes
  • 7
  • 6
14 Comments
 
LVL 1

Expert Comment

by:TomDromi
ID: 29367202
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
 

Author Comment

by:gaynes
ID: 29367560
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
 
LVL 1

Expert Comment

by:TomDromi
ID: 29368166
for how many clients do you need that?
Tom
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Comment

by:gaynes
ID: 29368952
1
0
 
LVL 1

Expert Comment

by:TomDromi
ID: 29369296
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
 
LVL 1

Expert Comment

by:TomDromi
ID: 29370639
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
 

Author Comment

by:gaynes
ID: 29374267
I am not sure you can even send a spreadsheet attachment with a text?
0
 
LVL 1

Expert Comment

by:TomDromi
ID: 29374526
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
 

Expert Comment

by:LadyHagood
ID: 29391317
just stumbled acrross this thread, can a standard message be sent to any phone number not just an iphone from access 2003?
0
 

Author Comment

by:gaynes
ID: 29399791
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
 
LVL 1

Expert Comment

by:TomDromi
ID: 29450062
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
 

Author Comment

by:gaynes
ID: 29456188
Then I have to worry about uploading the spreadsheet every night.
0
 
LVL 1

Expert Comment

by:TomDromi
ID: 29456649
I think this will give you the way:
http://office.microsoft.com/en-us/access/HP052612171033.aspx

Tom
0
 

Accepted Solution

by:
gaynes earned 0 total points
ID: 32781804
this is apparently not possible
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question