steve.waye
Board Regular
- Joined
- Jul 8, 2010
- Messages
- 68
Hi all. Hoping someone can help with some VBA.
I have a list of students (up to 500) in a spreadsheet. The list includes email addresses and mobile numbers.
To send an email to selected students I just filter the spreadsheet and highlight the email addresses that I want to use, and then paste these into my email client. Not too cumbersome.
Sending an SMS however is a little more involved...
Any help would be appreciated.
Thanks, Steve
I have a list of students (up to 500) in a spreadsheet. The list includes email addresses and mobile numbers.
To send an email to selected students I just filter the spreadsheet and highlight the email addresses that I want to use, and then paste these into my email client. Not too cumbersome.
Sending an SMS however is a little more involved...
- First I select the cells with the relevant mobile numbers (which are formatted as 0412 345 678).
- Then I paste these into another sheet which automatically converts the numbers into the correct SMS format for my email client (formatted as 0412345678@sms.domainname.edu.au).
- Then I copy the formatted numbers and paste them into the "To:" field of my email client.
- Highlight relevant mobile numbers
- Click an "SMS Selected Students" button
- Email client automatically launches a new email page with formatted numbers entered
Any help would be appreciated.
Thanks, Steve