[v6emw]

I need help to find a solution that always works to my current problem:

Using Excel 2007 VBA I need to send a similar text message to say 50-100 people using Nokia PC suite. Has anyone found a way of doing this?

I have found a way of opening and then initially controlling PC Suite in VBA by using sendkeys, however it always falls over at some point as it loops through all the staff.

Scenario is simple - I have built a rota for where I work. Each employee receives an email with their rota in it for the coming week; I also want to send a short text message to each employee telling them that their rota is in their email inbox and details of their next shift.

So, the VBA code loops through each staff member, customises the text message contents but always falls over for no apparent  part way through the loop. I have succeeded in getting it to work for 5 people, but it falls over when it gets into double figures.

I could get it to send bundles of 5 but there must be an easier way; someone must have tried doing what i'm doing and succeded!

Thanks

[navalgupta]

Hi,

I would like to know the way in which I can achieve the above. i.e. Send SMS from Excel. even 2-5 sms will work for me..

Thanks...