Sending pages Via VBA

[gol4]

I have a customer service center where we log incoming calls into an Access database. After the calls are logged in we send the page to the staff via an alpha numeric pager. We currently use software provided by our pager company to send these pages. Based on the call we either page one person or group page several persons. The problem I have is the paging software fails often, leaving pages unsent. I have attempted to send these pages via e-page ( which is available in our area) but they are sometimes held in a queue for longer periods of time then is acceptable. My question, has anyone done this in VBA? I need to dial the pager company send the string, perhaps multiple times, and then confirm the page was accepted. We are averaging over 7000 calls per month and 1/2 of those go to groups of 2 or more. Table design and such for the groups I can handle. Dialing the phone and sending the page is where my brain starts to hurt.Any suggestions would be appreciated. Working and tested code even more so

 

[DougP]

I have done this with Numeric Pagers not Alpha Numeric.<br>I wrote a Visual Basic Application because Access cannot "access" the com port directly.

 

[Amiel]

<br>There are two distinct versions of the Telephony API (TAPI) that are a part of the Win95 and NT OS. Yes you can do pretty much anything with the API including an entire call center package. Since this is a subjet that is dear to me, ...well you can use this page as a starting point.<br><br><A HREF="

http://support.microsoft.com/support/kb/articles/Q148/8/57.asp?LN=EN-US&SD=gn&FR=0"

TARGET="_new">

http://support.microsoft.com/support/kb/articles/Q148/8/57.asp?LN=EN-US&SD=gn&FR=0</A><br><br>have

fun. <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>

 

[Guest_imported]

Thanks for that info Amiel. I spent the last hour making me my own little version of Autodailer . Now the question becomes How do I send my call string after the call has been placed without getting com errors. You also say this subject is dear to you, I assume you've walked this same road I'm about to venture on. With the tools avaliable will I eventually be able to create a product that will function without failures or am I better off to live with existing software packages? Am I wasting my time?

 

[Amiel]

There are plenty of existing products that are flexable enought to handle the tasks that you mention. I wouldn't&nbsp;&nbsp;attempt writing one, unless you've just got lots of time on your hands. <br><br>Take a look around (the net) to see what else is available. The name 'PageMaster' comes to mind.&nbsp;&nbsp;Luck. <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>