Do you have a list of email addresses in Excel to whom you want to send emails? Here are step-by-step instructions on sending out personalized individually-addressed emails to each person.
Step 1: Make sure that your data is correctly setup inside Excel
Check your spreadsheet to ensure that it has data similar (it doesn’t have to have exactly the same columns) as below. Things to be careful of are listed under the image.
The first row should have the names of columns/fields. You can have just one field (Email address) or as many different fields of data as you want.
You need to (obviously) have the email address in one column.
Rows after the first row will have the actual data.
Step 2: Install Email Merge for Excel
EmailMerge for Outlook is the fastest, easiest and safest way to send out personalized emails using data in Excel. You can try it free for 30 days.
If you haven’t done so already, download and install Email Merge for Outlook.
If you have installed the software properly, you should see the EmailMerge button on the ribbon inside Outlook.
Step 3: Click on the Email Merge button inside Outlook(shown above) to open the Email Merge menu
Click on “Create a new merge”
You can start your email merge process with a Blank email or using an Email template (pre-set email) from the list. Make a selection and click Next.
EmailMerge can use data from many sources including from inside Outlook and Excel. In this case select “Excel File” and then select the Excel file you want to use.
Step 3: Where are your Contacts?
The screen will now show you a list of all the sheets in your Excel workbook.
Select the sheet in which your contacts are and Click Next
Step 4: Who do you want to send this e-mail to?
The screen will display all the contacts on the selected sheet.
Select (tick) the people to whom you want to send this email and click “Next”
Step 5: Confirm Your Mailing List
EmailMerge will display a list of all contacts you had selected to send your email to.
If you need to make any changes, click on the “Back” button. Otherwise click “Next” to continue with the remaining steps of the Wizard.
The remaining steps of the EmailMerge Wizard allow you to:
- Preview how each customized email will look on both computers and mobile devices
- Send all the emails at once or in smaller batched.
- Send the email immediately or scheduled at a later time or date
- Track opens and clicks on your emails
- Choose the account to send the email out from… and much more
Click “Finish” to send out your emails.
EmailMerge for Outlook is the fastest, easiest and safest way to send out personalized emails using data in Excel. You can try it free for 30 days by clicking on the image below.
You can download the full NBA season schedule or only your favorite team’s schedule and load it into Outlook so that you don’t miss out on any of your favorite team’s matches.
The regular season will begin on October 25th, 2016, with the 2016 NBA champion Cleveland Cavaliers hosting a game against the New York Knicks. so gear-up with your favorite team’s jersey, hats, cheering gears etc and plan in advance with friends and families to enjoy the games at home or at the venues.
1. Click on the link’s below to download the full NBA schedules for ALL teams and sun it to your Outlook: Download the 2016 NBA Season Schedules for all teams
If you only want schedules of your favorite team, click on the appropriate link below:
Once you click on your favourite teams link, the webpage for your Team will open up and provide you with the options shown below:
2. Select the “OUTLOOK” option which will than trigger your Outlook to connect to the schedules server as shown below:
3. Once Outlook starts up it should prompt you to “Add this internet calendar to outlook and subscribe to updates”
4. Once you select “Yes” on this prompt it should open up your calendar and give you a view of the scheduled matches as shown below:
Thousands of Outlook users use EmailMerge for Outlook to send personalised emails to their customers. Now you can also know exactly who has opened or clicked on an email…and do follow-up merges to them.
The video above shows you exactly how easy it is to send and track your emails… but here’s a quick summary.
Use the Email Merge Wizard as normal. The last step of the Wizard has a tracking section as shown below.
Tick the check box, give this merge a name and click Finish to create and send out your emails.
Viewing Tracking Data
You will be notified immediately if someone or a recipient opens or clicks on a link on your email.
This notification is displayed at the bottom right hand corner of your screen but you can optionally get email notifications that tell you who has opened the email, where and using what device.
You can also view summaries and details of the tracking information on EmailCaddie.com, a website that we have created specially for tracking.
Doing Follow-Up Merges
EmailMerge doesn’t just tell you who has opened or clicked on an email. You can also use the information inside EmailMerge to do follow-up merges. For example:
You can send out additional information only to the people who clicked on a particular link or..
You can send out reminders to the people who have not opened your email.
The video above shows you just how easy this is to do.
If you’re new to EmailMerge, download a 30-day trial today and see why thousands of Outlook users around the world use it daily to communicate with their customers and members.
What has a Wheelbarrow race got to do with Microsoft Outlook? Your Outlook team at Standss is competing in a wheelbarrow race to raise funds for special-needs children here in Fiji.
Long-time readers and customers will know that the team at Standss does a lot of work with child-based charities in Fiji. One of the charities that we have worked very closely with over the last few years is the Frank Hilton Organization.
What is the Frank Hilton Organization?
The Frank Hilton Organization was established in 1960 to provide education and related services to children with disabilities in Fiji.
Fiji is a developing country where children still do not have easy access to many of the facilities and services that children in developed countries do. This is particularly true for children with special needs.
We chose to work with the Hilton Special School because of the excellent work that they have done over the years. Their work enables these children to enjoy their childhood, to learn, to grow and to have futures that the rest of us often take for granted.
On our visits to the school we have always found the children treated with the gentleness, firmness and dignity that all children deserve.
What is the AMAZING Wheelbarrow Race?
This year the team at Frank Hilton are organizing a first ever Amazing Wheelbarrow Race as their annual fund-raising event. Groups of up to 8 people can enter as a team and race for 3 laps around the newly rebuilt Albert Park in Suva.
One team member will actually need to be in the Wheelbarrow at all times (with the appropriate safety gear on) while the others take turns pushing.
The entry fee for the competition is $5,000 per team which can be raised through fundraising and sponsorships.
Prizes will be awarded for the first 2 teams to finish as well as best dressed and most funds collected.
How you can Support us?
The team at Standss decided that we will pay for the entry fee of $5000 from our revenues. This is only possible thanks to your support of our Outlook addons.
However… if you are interested you can further support our efforts to help the Frank Hilton Organization by:
Purchasing Additional Outlook Addons for You and Your Team (a portion of which will be donated)
Do you need to schedule appointments, calls etc with people in different time zones? Here’s how to make sure that you’re both there at the same time by getting Outlook to show you the time in both zones at the same time.
If you are using Outlook with Office 365 or Exchange Server:
–Open up the New Appointment form (Go to your Calendar in Outlook and click New Appointment).
–Click Invite Attendees.
–Click Time Zones on the Ribbon.
–Select the time zone of the other person from the drop-down.
Now on the Room Finder Task Pane that should be displayed in the right hand side, select a date and time. As you change the date at time, you will see that the date and time for the other person will change automatically.
If you want to create the appointment and send a meeting request to someone, enter their details in the To field and then click Send.
If you want to create an appointment without sending a meeting request, click Cancel Invitation on the Ribbon and then click Save and Close.
If you are NOT using Office 365 or Exchange Server:
You won’t be able to access the full functionality described above but you can achieve the same results with the following steps.
–Open up the New Appointment form (Go to your Calendar in Outlook and click New Appointment).
–Click Time Zones on the Ribbon (see image above).
–Select the time zone of the other person from the drop-down.
–Enter the date and time in the fields and click Save and Close. The meeting will now be created on your calendar with the time shifted to the appropriate time in your time zone.
–Check your calendar to ensure that you did your calculations correctly and the meeting is at a time convenient to you..
If you want to send a meeting request to someone, open the appointment again (double-click), enter their details in the To field and then click Send.
I hope that you find this tip useful.
We have clients all over the world and I use this every day to ensure that all participants to our meetings arrive at the correct time, even when we are many miles and time zones apart.
Is you Inbox full of emails that you don’t want to work on but you don’t want to delete either? Here’s a tip on how you can keep them in your Inbox and remove them at the same time. Confused? Read on.
My general strategy to Get Things Done is to only keep emails in my Inbox that I actually need to work on. However..
There are many emails in my Inbox that I know that I won’t be working on today… or even this week. I don’t want to delete them because I (maybe) will work on them someday.
Here’s a simple thing I do weekly that helps me have a clean Inbox to work from… and still keep those unurgent emails around.
I will show you two ways of doing things… a manual way and an automated way using eemnders for Outlook.
1) The Automated Way
Once a week I do a Weekly Review.
I look at the emails and decide what I will work on this week. Those emails get to stay in my Inbox. The others get moved out.
I use eeminders for Outlook to move emails out of the Inbox. I’ll show you the steps in a minute but basically…
eeminders installs inside Outlook lets me select emails to “defer” or “snooze” to a date and time of my choosing. The selected emails get moved out of your Inbox but then magically reappear on your chosen date and time.
You can use eeminders to snooze your non-urgent emails for a week using the following steps.
Go to your Inbox.
Select the emails that you want to move out (press the CTRL button to select multiple emails if you want).
Right-Click over one of the emails and then click eemind me – 1 Week.
The selected emails will get moved out of your Inbox into another folder called eeminders. A week later they come back into my Inbox.
Why I like this?
- I don’t have to think too hard and the process is FAST. It’s not like I am deleting the emails. It is easy to identify emails that I won’t be working on this week.
- The emails will come back into the Inbox so I WON’T FORGET THEM! Chances are that in next week’s weekly review, I am just going to defer them for another week but that’s OK. At least I won’t forget them.
- In case I run out of things or change my mind, I can always go to the eeminders folder and retrieve an emails that I need to work on.
2) Doing this Manually
(In case you skipped it, please read the Automated Way above first to understand the idea of the Weekly Review)
You could also do this manually by creating a folder and calling it something like Next Week. Then when you do your Weekly Review:
- Go to the Next Week folder and drag any emails that you plan to work on this week into your Inbox.
- Go to your Inbox folder and drag any emails that you do not plan to work on this week to the Next Week Folder.
My own experience (and the experience of many many Outlook users who we work with) is that the manual method requires too much will-power and discipline and after a while we stop doing it.
I have been using eeminders in this way for the last 3 months and my Inbox has been a joy 🙂 to work from.
The majority of the emails that you send will be read on Smart Phones and tablets. That means you could be missing out on important business if your emails are not displaying correctly on mobile devices.
In this post we look at things you MUST do to ensure that your emails are displayed correctly on computers, tablets and most importantly smart phones.
Stats say 55% of email is now opened on a mobile device (Litmus “Email Analytics” -March 2016) and the numbers are expected to increase. In fact it is already up 500% since 2010.
Here are 3 quick and easy things you can do in Outlook to ensure that your emails look right, get read and most importantly get responded to.
- Use a BIGGER font size
Mobile device screens are small and you need to make sure that your text can be read easily. We recommend a minimum font size of 14 pts for body text.
- Use a dark text color (Black) on a light background (White)
Don’t get too creative with your font colors and backgrounds. Dark text on a light background usually works best.
It is readable in most conditions…like in bright sunlight. It is also readable if users have turned down the brightness of their screens to save battery life.
- Don’t use too many images
You can’t assume that your images will be displayed because many mobile operating systems (e.g. Android) turn images off by default.
Users often don’t download images in order to save data.
We recommend that you add images for effect but still write emails that convey your full message even if the images were turned off.
4th (Bonus) Tip: Write what is important at the top of the email
People often use their mobiles for “pruning” their emails before doing the real reading and responding on their computers.
Make sure you make your point quickly or your email could be deleted and never actually re-read on the desktop.
5th (Bonus) Tip: RESPOND QUICKLY! Don’t wait for the recipient to reply!
According to lead response management survey, your odds of qualifying a lead in 5 minutes versus 30 minutes drops 21 times.
That’s within the first 30 minutes!
The same survey shows that you have 10x greater chance of just contacting leads if you contact them within the first hour.
We are relooking at all of our Outlook addins for Business to ensure that they continue to serve you in the new era of mobile devices. Next week, we will be making an announcement for Email Merge for Outlook which thousands of Outlook users are using to send out sales and marketing emails to their customers.
In the meantime, please let us know if you have your own tips on making emails more readable on mobile devices by leaving a comment below.
For all you NFL fans out there, it’s that time of the year again so gear-up with your favorite team’s jersey, hats, cheering gears etc and plan in advance with friends and families to enjoy the games at home or at the venues.
Week 1 kicks off on Thursday, 8th of September with the annual kickoff game featuring the defending Super Bowl 50 champion Denver Broncos hosting the Carolina Panthers. The season will conclude with Super Bowl LI, the league’s championship game, on Sunday, February 5th 2017, at NRG Stadium in Houston, Texas….A Game not to be missed!!!
You can download your favorite team’s schedule and link it into Outlook so that you don’t miss out on any of your favorite team’s matches.
1. Click on the links below to download the schedules and link them to your Outlook:
2. Once you are on your favorite teams Schedule Page, Click on “Add to Calendar” and a pop up screen opens up.
3. Select “Desktop” and click on “Outlook” to download the Web Calendar, once you have done this than select “Add to Calendar”
4. Outlook prompts you with “Add this internet Calendar to Outlook and Subscribe to Updates?” click on “Yes” to simply add the calendar to your Outlook.
5. The times for all the games will now be in your Outlook.
Stock-up the chilled Beers, snacks and enjoy the games.
May the best team win.
In this post we look at 3 simple mistakes that emailers make that can cost their companies everything from a few wasted minutes, to upset co-workers to lost clients.
We also look at steps that organizations can take to protect their people and themselves from these mistakes.
Hitting Reply All too often
Just because the email that you received was addressed to multiple people does not mean that your reply should also go to them all.
We all already receive too many emails and it can be annoying to receive emails with one or two words acknowledging receipt of the emails etc.
They may not be as bad as spam but they have a similar effect… they take our attention away and waste our time.
For Individuals: Your unneeded reply-to-alls could be annoying your contacts and even training them to start ignoring your emails. Think carefully before you click Reply All.
For Organizations: Unneeded Reply-All emails cost businesses many hours of lost time and productivity every year. Reclaim this time by using addons that get users to confirm that they do in fact want to email everyone when they click Reply-All.
Forgetting to email everyone
On the flip side to the above, sometimes a Reply-All makes senses (or at least a Reply-to-Some of the original recipients).
This may be required to keep everyone in the loop or for your own personal protection.
For Individuals: Always check if an email has multiple recipients and decide who should be part of your reply
For Organizations: A lot of valuable time can be wasted resending emails to missed recipients. Use an addon similar to SendGuard which will prompt when you do a Reply (and not a Reply-All) on an email with multiple recipients that you may also want to include others in it. SendGuard even lets you change the recipients without having to go back to the email.
Emailing the Wrong Person
Outlook has a great (and also greatly dangerous) feature called Auto-Complete. You don’t need to remember anyone’s email address… type in a few characters in the To, CC or BCC field and Outlook fills in the email address for you.
Unfortunately, this makes it very easy to accidentally send the email to the wrong person. The Internet is fill of disaster stories where this has led to lost clients, large lawsuits etc.
For Individuals: Check your email’s recipients before clicking Send. Better yet, install software similar to SendGuard that will display the recipient’s name(s) to you again before sending the email out.
For Organizations: Deploying software similar to SendGuard for Outlook may also provide additional legal protection because it shows that the organization took extra steps to protect against accidents of this king.
How to Protect Yourself and Your Organization
Our SendGuard for Outlook is already protecting thousands of Outlook users in businesses of all sizes around the world.
- SendGuard detects potential mistakes in emails and prompts users before emails get sent out
- Organizations may have additional protection in lawsuits because (if needed) they can show that they took extra steps by using SendGuard to minimize incidents of mistakes such as this.
SendGuard consists of a number of different email security features, but based on user feedback we recently introduced the new SendConfirm and Reply Guard bundle to specifically protect against the mistakes identified in this post.
If you are looking for a way to add sticky notes to your emails, you need to read this. We have just updated our best selling Outlook addin Email Notes for Outlook.
This update is free for existing Version 2 users but adds both speed and stability (particularly for Outlook 2016 and Office 365 users).
Your notes do not change the original email in any way.
Your notes are confidential so there is no risk of accidentally sending your private thoughts in a reply or forward.
Your notes are intelligent so that you can see all notes for a conversation easily (instead of searching for old emails to find them).
Our users tell us you can use Email Notes to:
1. Remind yourself why they left an email in the Inbox
2. Add additional information that you have gathered from phone calls or face-to face meetings
3. Add any to-dos related to the email for later.
How will you use Email Notes to improve your responses and productivity?
- Charity Projects
- Company News
- eeminders for Outlook
- Email Marketing
- Email Notes for Outlook
- EmailMerge for Outlook
- EmailTags for Outlook
- InsertText for Outlook
- MailSync For NetDocuments
- Office 365
- Office Tip
- Outlook 2010
- outlook 2013
- Outlook 2016
- Outlook as a Business Tool
- Outlook Calendar Tip
- Outlook Contacts Tips
- Outlook Data Backup
- Outlook Email Filing & Management Tip
- Outlook Email Tips
- Outlook Installation/Setup
- Outlook Mail Merge
- Outlook Performance
- Outlook Search Tips
- Outlook Shortcuts
- project management
- QuickFile for Outlook
- Sales and Marketing with Outlook
- Send Confirm
- SendGuard for Outlook
- Sending emails
- Signature Switch for Outlook
- Smart Schedules for Outlook
- SPAM Filtering in Outlook
- Special Discount Offers
- Windows Tip
- February 2018 (2)
- January 2018 (1)
- November 2017 (1)
- October 2017 (5)
- September 2017 (3)
- August 2017 (2)
- July 2017 (2)
- June 2017 (2)
- May 2017 (1)
- April 2017 (2)
- March 2017 (1)
- February 2017 (4)
- January 2017 (2)
- December 2016 (1)
- November 2016 (2)
- October 2016 (3)
- September 2016 (4)
- August 2016 (3)
- July 2016 (5)
- June 2016 (2)
- April 2016 (1)
- March 2016 (2)
- February 2016 (1)
- January 2016 (3)
- December 2015 (3)
- November 2015 (1)
- October 2015 (2)
- September 2015 (3)
- August 2015 (2)
- July 2015 (4)
- June 2015 (3)
- May 2015 (2)
- April 2015 (3)
- March 2015 (4)
- February 2015 (3)
- January 2015 (3)
- December 2014 (1)
- November 2014 (1)
- October 2014 (3)
- September 2014 (6)
- August 2014 (8)
- July 2014 (7)
- June 2014 (7)
- May 2014 (6)
- April 2014 (2)
- March 2014 (1)
- February 2014 (1)
- January 2014 (2)
- December 2013 (4)
- November 2013 (6)
- October 2013 (7)
- September 2013 (8)
- August 2013 (11)
- July 2013 (9)
- June 2013 (9)
- May 2013 (10)
- April 2013 (9)
- March 2013 (8)
- February 2013 (7)
- January 2013 (4)
- December 2012 (4)
- November 2012 (9)
- October 2012 (3)
- September 2012 (3)
- August 2012 (5)
- July 2012 (2)
- June 2012 (5)
- May 2012 (9)
- April 2012 (7)
- March 2012 (10)
- February 2012 (7)
- January 2012 (8)
- December 2011 (3)
- November 2011 (4)
- October 2011 (6)
- September 2011 (8)
- August 2011 (11)
- July 2011 (9)
- June 2011 (2)
- May 2011 (7)
- April 2011 (7)
- March 2011 (8)
- February 2011 (8)
- January 2011 (7)
- December 2010 (6)
- November 2010 (9)
- October 2010 (8)
- September 2010 (8)
- August 2010 (14)
- July 2010 (13)
- June 2010 (15)
- May 2010 (13)
- April 2010 (15)
- March 2010 (5)