SMSCountry Excel Filter Feature

Condition I

Condition :- I want to send SMS to those clients whose Buy Quantity is between 500 and 3000.

Case Study:- It can be done through manual selection if you have very few records, may be up to 10. But what if you have 100 or 1000 or more records all scattered. You cannot spend your time searching for those users.

Hence here is the right solution for you...








Solution :- Click “Filter” and Enter Filter Formula.

Formula :- X [ Y] where
-> content inside [ ] are optional and can be repeated if required).
-> X and Y = ##

Example :- #G# > 500 and #G# < 3000
Finally click on “Ok” followed by “Send”



Following confirmation box will be displayed

Condition II

Condition : I want to send SMS to only those users whos symbol is “TATASTLCCPS”

Case Study: In above sheet only “Basheer” and “Ramesh Ankam” should receive SMS. But what if there are 1000 scattered records in the sheet out of which 250 satisfies this condition.

So here is the right solution for you...








Solution : Click “Filter” and Enter Filter Formula.
Example : #F# = ‘TATASTLCCPS’
Finally Click on “Ok” followed by “Send”


Following confirmation box will be displayed

Condition III

Condition : I want to send SMS only to a particular series of mobile numbers say "9198663".

Case Study: It is very difficult to compare each mobile number with the given series. In the above example after carefully examining we can say that “Ramesh Ankam” and “Saif” should receive an SMS. But what if the sheet contains thousands of records.

Here we bring the perfect solution for you...









Solution : Click “Filter” and Enter Filter Formula
Example : #C# like ‘9198663%’
Finally Click on “Ok” followed by “Send”


Following confirmation box will be displayed






Here in the above presentation, I have shown you only three different examples of using Filter. There can be many more cases where filters can be applied.
Ex: comparing dates, age, special characters, words, etc...

THE END.

Excel Plugin Application-defined or object-defined error

Dear SMSCountry Excel Plugin User,

If you are getting the following Error while send SMS from SMSCountry Excel Plugin "Application-defined or object-defined error" then please perform the following checks to resolve this issue.

Every Excel Sheet has got a unique Identity for every column as its column heading ex: A B C ... till ZZ.Inorder for us to specify column name in our excel software, we have used #A# instead of just specifying A to differentiate it from normal english characters. Since # is used by us as reserved character, issue arises when your message also as # in it.




Cause Of Error :-
The above picture shows you error which might occur when you are using #(hash) character in your message.

Solution :-
Please try sending SMS after removing # character from SMS Message...

Ex:-(Below message gives you error in Excel Plugin as Application-defined or object-defined error since there is # repeated in your message too.)
Dear #B#
Your Account # is #C#
Your Balance is #D#

To resolve the erroe you can edit message as.
Ex:-
Dear #B#
Your Account No. is #C#
Your Balance is #D#


I have removed # character from message and it works fine. As shown in above image.

That's it for this topic. If still that doesn't help then let me know so that I can give you some more solutions for it.

How To Change The Column Heading(Identity) In MS Excel

Dear Friends,

As we all know that excel sheet will have column headings using which we perform all mathematical operation, formulas etc. The headings can be A,B,C,...ZZ format or 1,2,3....etc. Depending on our requirement we can change these using excel settings. Mostly in case of performing mathematical calculations using formulas, we prefer to have column headings as characters instead of numbers. Here I will show you "How To Change The Column Heading(Identity) In MS Excel" from numbers to characters and characters to numbers.

You just need to follow the below steps to change your Microsoft Excel Column Headings from A,B,C... to 1,2,3... or vice versa.

How To Change The Column Heading(Identity) In MS Excel

1) Open Excel Sheet

2) Click on Excel Office Button (Top Left most) then

3) Click on "Excel Options" then
You will get an "Excel Options" Interface.

4) Click on "Formulas" (at left side) then

5) UnCheck "R1F1 reference style" then (For Alphabetic Rows)
OR
5) Check "RR1F1 reference style" then (For Numeric Rows)

6) Click on "Ok"

Thats it, you have successfully converted your Excel Sheet column Identity from 1,2,3.... to A,B,C...


Please refer the snapshots for the same.








Let me know if you have any queries in this regard

SMSCountry Excel Plugin Grouping Feature

What is Grouping?
Grouping refers to merging of same type of data into single place. In our case it refers to merging same type of records in to one.

What are the advantages of Grouping?
1) Lowers the SMS cost to sender.
2) Avoids unnecessary repetition of data.
3) Makes SMS reading simple, easier & comfortable for the receiver.



Problem: I want to send SMS to all my clients listed above.
Using normal procedure I will be charged for 11 SMS for sending message even to repeated clients. Instead I need a solution with which I can send all corresponding data to its client in a single SMS. This will help me in:

1) Saving SMS cost as it would charge me only 3 SMS or 6 SMS for long message instead of 11.

2) Also it would be easier for my client to read all his data in a single message instead of opening separate messages.
Lets see how we will implement this ?????????????????



Solution : Grouping
STEPS TO SEND GROUP SMS :-
step 1: Sort your data according to client id (column F) or mobile number (column G)

Step 2 : Enter Message-> row range,->select mobile number column,->Advance Option & Preview check box ->select Unique Column(Group by column) with which you want to Group, Enter Header Text & Footer Text which you don’t want to repeat and Click on Send.




You will be prompted if your message has characters > 160.

Click “OK” to continue sending long SMS.




A Preview dialog will be displayed with customized SMS text. Here it shows 3 SMS will be pushed with each SMS more than 160 characters in length. So total 6 SMS cost will be charged.




You can view each SMS details by using “Next SMS >>”
and “<< Previous SMS” buttons.

Click On “Send SMS” shall directly proceed to sending SMS.



On successful sending of SMS, you will see an SMS Sent Confirmation dialog.




THE END.

SMSCountry Excel Preview Feature

Feature Discussed :- “Preview”

Why Preview is required?

As SMSCountry provides customized bulk messaging from Microsoft Excel Plug-in, one must know how the message will appear after customization.

Preview Feature provides following facilities:-

1) Displays exact message which will be forwarded to the recipient along with mobile number.

2) Shows number of characters message contains.

3) Number of SMS’s clubbed into single SMS.

4) Total number of SMS’s selected for sending SMS.

5) Total number of SMS’s charged.





Problem: I want to send SMS to all my clients listed above.
From above data we can say that 12 SMS will be required to send the details.
But there are some clients who have more then one transaction ex:- “CJR009” .
Hence we can use “Advanced feature” to group all his records in to single SMS.


Lets check...
...
..



Enter the Message -> specify the row range -> select Advanced Options -> select “Preview and Send” -> Click on “Send” button (as shown above)

Until now we were unknown of how actually the sms is grouped into one and how does it appear to the client once sent.

So, here is the solution for you...

On selecting the option of “Preview and Send”, a dialog will appear that displays each and every SMS message in exact format as it appears on receivers mobile.




You can view each SMS details by using “Next SMS >>” and “<< Previous SMS” buttons.
Click On “Send SMS” shall directly proceed to sending SMS.

Next Example :

“Preview” with “Filter Feature”

Suppose I have hundreds of records in my sheet. According to my filter formula “#G# > 600” I don’t know how many SMS will be sent and to whom it will send.

In such case, here is the solution.




You can proceed sending using “Send SMS” button or click “Cancel” to cancel all the messages.

THE END

Automatically Forward Emails From Outlook Express 6

Following are the steps to forward emails from Outlook Or Outlook Express!!!

In Outlook Express: (6)

1. Click on the Tools menu and select Options.


2. In options select the Send tab.


3. Make sure the settings for Mail Sending Format has the Plain Text radio button Selected.


4. Then click the Plain Text Settings button.


5. Leave the Message format on “MIME”.


6. Uncheck the box at the bottom that says “Indent the original text with…”.


7. Click OK.


8. Now click on the Signatures tab.


9. Make sure if you have a signature(s) listed that the box labeled “Don’t add signatures to Replies and Forwards” is checked. Then click OK.


10. Click on the Tools menu and select Message Rules, and then select Mail.


11. Click on the Mail Rules tab.


12. Click the New Button.


13. In the area labeled 1. Select the Conditions for your rule: Select the box next to Where the Subject line contains specific words (in this example we will use the subject but you could use account or email address if desired).


14. Then in the area labeled 2. Select the Actions for your rule: Select the box next to Forward it to people.


15. In the area labeled 3. Rule Description… click on the blue link that says “contains specific words” then type your member code in the box and click on the Add Button and then click OK.


16. Then in the same area click on the blue link that says “people”, then type in the email address(Ex: < MobileNumber >.< Your SMSCountry Username >@smscountry.net or xyz@gmail.com ) of where you want the email to automatically forward to and then click OK.


17. Click OK.


18. Click OK.

In Outlook (2003)

1. Click on the Tools menu and select Options.
2. In options select the Mail Format tab.
3. Make sure the settings for Message Format is using the Plain Text option.
4. Under the Select Signatures for account area at the bottom of that window, make sure
that is listed in the menu for the option of Select Signature for replies and
forwards. Then click OK.
5. Click on the Tools menu and select Rules and Alerts.
6. Click on New Rules.
7. Click the Start from a blank rule radio button. Then click Next.
8. Select the box next to With specific words in the subject (in this example we will use
the subject but you could use account or email address if desired).
9. In the area labeled Step2: Edit the rule description… click on the blue link that says
“specific words”, then type your member code in the box and click on the Add Button
and then click OK. Then click Next.
10. Select the box next to forward it to people or distribution list.
11. In the area labeled Step2: Edit the rule description… click on the blue link that says
“people or distribution list”, then type in the email address of where you want the
email to automatically forward to and then click OK. Then click Next.
12. Then click Next.
13. Then click Finish.
14. Click OK.

SMSCountry Excel Template Feature

New Feature:- “Save Your Message” (Save Msg)

Description & Use Of This Feature

This feature allows user to save his/her message into our database and access it whenever & wherever needed. This is very similar to mobile phone templates(sample messages) concept except that here user can decide the message text.

Save once, Use Everytime:-
As many users have common sms format, they can save it once and use it everytime. Thus saving their time too.

Additions in UI (Save Msg)
Check Box as “Save Msg”. Button as “Display Saved Messages”. Text Box as “Enter Msg Name” Drop Down List as “Select A Message”

How to save your message?
1) Enter your message in message text area. 2) Select “Save Msg” Check box. This displays “Enter msg Name” Textbox and a button “Save”. 3) Enter your desired name in the field provided. 4) Click On Save Button. 5) You will get an alert saying “Successfully Added”

How to View Saved Messages?
To view your saved messages : - Click on “Display Saved Messaged” Button. You will be prompt to Login (if not already). Once logged in you can view all your saved Messages in a drop down list called “Select a message”. Once you select a message name , the corresponding message will get displayed in the message area.