Executing AT Commands thru VBA

[rd.prasanna]

HI All,

I am working on the small CRM project.

In CRM tool when customer raise the complaint for there issue system should automatically send Mail and SMS to the registered Email and Mobile Number.

Email part i have completed, But got stuck in sending sms process.
Here im using USB Modem to send sms. I am using Putty application to run the AT Commands, When i am using the AT command manually its sending the SMS properly.
But i want to Automate the whole process using VBA. AT command can be saved in the .txt file and can be accessed using putty commands.



how to run the external dos commands in access, which execute the putty with txt file and send sms to the customer numbers.

I am working on access 2003/2010

Regards,
Prasanna R.D

[ranman256]

DOS died 20 years ago.

[June7]

We ran a DOS dBaseIV database until 2009 with WindowsXP. But we saw the writing on the wall and knew we needed to replace. MS removed all support for dBase files from Office 2010 (actually, maybe that is 2013) and AFAIK Windows7 does not support DOS applications.

Review https://www.accessforums.net/program...ens-43311.html

[rpeare]

Here is how you run an external process through vba:

http://stackoverflow.com/questions/1...from-ms-access

You will likely also need to issue a 'wait' command and executing that relies heavily on which version of access you are using/your users are using (32bit or 64bit)

[rd.prasanna]

Thank You June7 and rpeare...