Monthly Archives: November 2016


Print a Blank Outlook Calendar to Plan Your Year

By standss - Comments ( 0 ) Thursday, November 17th, 2016

1945256

As the year comes to an end, you probably need to do some planning. How will you finish this year in the best way possible… and how will you make the next year your most productive year yet?

One of the things that I find very useful in my planning is BLANK PRINTED CALENDARS. I print out one page per month and use that for planning. It really helps that I can have multiple months spread out in front of me on the table.

In this post I will show you how you can print out blank monthly calendars from Outlook (and also how you can print out calendars for any particular date range).

How to Print a Blank Calendar from Outlook

Go to the Calendar in Outlook.

Go to the Home tab of the Ribbon (if you are not already there)

Click Open Calendar – Create New Blank Calendar.

Enter a name for the calendar.

Ensure that your existing Calendar is selected for “Select where to place the folder” and click OK.

Create_new_folder

On the navigation pane on the left, you should see that the calendar that you just created added to the list of Calendars.

Tick it so that it is displayed (you will also need to untick the name of your normal Calendar).

Click File –Print.

Under Settings, select Monthly Style (or choose an alternative style if your prefer)

By default the current month will be printed. If you want to print a longer date range (you may plan for the first quarter…or even the whole year), click Print Option and enter the date range in the space provided.

Click Print.

I hope that you find your printed blank calendars useful for your planning. It may be old school but it works.

How to Email Merge from Excel and Outlook

By standss - Comments ( 0 ) Wednesday, November 9th, 2016

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.

Excel

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.

Merge button

Step 3: Click on the Email Merge button inside Outlook(shown above) to open the Email Merge menu

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.

Wizard

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.

Wizard3

Step 3: Where are your Contacts?

The screen will now show you a list of all the sheets in your Excel workbook.

Wizard4

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.

Wizard5

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.

Wizard6

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.

Untitled-4
Categories : EmailMerge for Outlook Comments ( 0 )

Search Blog

Archives