Julie continued with the Message Magic training from the Message Magic Advanced Users Guide
Managing your Skype ID’s and Unique Ids in a spread sheet ……Page 10 & 11
You can follow on the audio while reading below
So you have been playing around with the search patterns and you’re starting to acquire a large number of both search patterns and users…and it’s becoming a challenge to manage them.
The simple solution is to use a product like MS Excel or any other spreadsheet software. Simply save all your ids from Message Magic and then load them into your Excel ( or any other) spread sheet. I also get in the habit of sorting them but you need to eliminate duplicates, which you don’t really need to do if you are using the Message Magic Add Contacts feature because Skype won’t add the same user twice, but it IS important if you are just doing broadcasting.
If you need unique ids then go through the same process as in the previous section except you MUST first sort them in ascending order in column A. Then go through the following steps:
- Go to B2 and type in the following formula: =IF(A2=A1,0,1)
- Hold Ctrl, Press C
- Press the Left Arrow
- Press End, Press Down Arrow
- Press Right Arrow
- Hold Shift, Press End, Press Up Arrow, Press Enter
- Right Click Column Header B, Click Copy
- Right Click Column Header B, Click Paste Special, Click OK
- Go to B1, Type 1, Press Enter
- Click Data, Sort, Sort by column B, Ascending, OK.
This will leave you with some ZEROS in column B. All the rows containing a ZERO in column B are duplicates and should be deleted. Russ – Julie’s husband – made a video with a slightly different method, but it is very easy to follow.
Watch this video that Russ made showing us how it is done.
If you send a broadcast message to these users, it is very important to ensure that you do not have duplicate ID’s, and this video shows how easy it is to check for duplicates and remove them.
Julie and Jason mentioned Twitter stating that Twitter is a very powerful tool for communication and seeing that quite a lot of people is now buzzing on social media (social networking), which is becoming a hot topic on the internet, it enables people to get a message across to all their followers. ( Very similar to Message Magic). Twitter should not be used to push links as your followers might consider that as spamming. Use Twitter to add value and build relationships which can then turn into something more positive. Quite a remarkable point that was raised by Jason and emphasized by Julie is that social media (social networking ) is like being a teenager again. Become popular among your friends again, be yourself, and great things can and will happen to your business.
About Message Magic:
“There is only 1 reason a person won’t make money with this design and that is they quit before they get their “turn”.” - Grant Andrews.
There were several good questions asked…..
Q: I have a 64bit Vista operating system and I can’t get my Message Magic to operate.
A: The developers for Message Magic are busy developing the program to be able to work on the Vista 64bit. It does work with Vista 32bit.
Q: Are there still problems with AlertPay for paying our subscriptions.
A: In some instances this is working fine now, but in others not. We suggest that you keep an eye to see if your subscription is being paid – if not, you may have to reset your Alertpay settings, or change to a different Payment Pricessor. When an account has expired, the down line will disappear. By monitoring that, a member will know if their renewal subscription has been effected. With the pulses happening everyday now, it is important to always be up to date. If not, no commissions will be paid out for the time you are current with your subscriptions. If you have more than one account, be sure to check them all.
Q: If I upgrade my Skype from 3.8 to 4.0. will I be able to use Message Magic
A: It is not yet compatible with Message Magic and it also also prevents people from joining Skype rooms. Here is a blog post covering that issue in full.
- Julie’s Skype and Skype Tips: JulieWolf
- To learn more about Skype and to receive Julie’s FREE Skype tips, join her Skype room.
Julie Wolf
No Comments
Join the conversation and post a comment.
Trackbacks/Pingbacks