How to export your Outlook appointments?

Backing up your Outlook calendars offline

In absence of Outlook calendar synchronization with calendar server or services, such as CalDAV and Exchange servers, people would think about exporting their calendar entries into iCal files (.ics files), .csv files, .pst files, or Excel files. If you solely work with Outlook 2007, 2010, 2013, 2016 or 2019, then it is recommended to export them into .pst files for the best import result in the future. 

However, users most likely export Outlook appointments for use on other application or database import. The .csv method is not a good choice because foreign language characters in calendar entries will be corrupted after exporting. Thus, the best and the most compatible way to export is using iCal method.

Export Outlook calendar to Excel

EVO staff has once again made some useful Outlook add-in after EVO Collaborator for Outlook. It is called Power Toys for Outlook. This collection of add-ins include a nice Outlook calendar export tool. There are 4 ways that PTO exports Outlook appointments:

1. Export appointments as vCalendars (Outlook ICal (ics)) – This is as same as Outlook’s Save As except Outlook can only save one appointment per operation. PTO is able to save the whole calendar folder at once.

2. Export appointments as vCalendars (iCal (ics); Olson Timezone UTF8) – This is the same as #1 except saving appointments in term of Olson Timezone and UTF8. Olson Timezone is the most widely used time zone system except Windows Timezone. If you export your calendar events to elsewhere such as Google Calendar or other calendar services, then the receiving party will not be able to recognize it and fail the import. Yet, deployment of UTF8 prevents foreign language characters turning into corrupted characters.

3. Export appointments into one single vCalendar (iCal (ics); Olson Timezone UTF8) – Since vCalendar protocol is able to store multiple appointments in one single file, PTO saves the hassle of managing 100s or even 1000s of iCal (ics) files.

4. Export appointments as Excel Document – PTO enables you to output all Outlook calendar events into an Excel file for better viewing purpose with forking in nearly all commonly used fields in Outlook appointments.

Here is a general guideline to export your Outlook appointments:

1. Download Power Toys for Outlook from EVO’s Official website.

2. Close Outlook and run setup.exe with administrator’s privilege.

3. Open Outlook and click on Power Toys ribbon at top.

4. Click on Export appointments.

5. Select your Outlook calendar folder.

6. Click on 1 of the 4 export types as mentioned above.

export outlook calendar to excel

7. A folder created by date will pop up showing all iCal (ics) files accordingly.

As you can see, exporting Outlook calendar becomes as easy as 1-2-3.

How to export your Outlook contacts?

Backing up your Outlook contacts offline

In absence of Outlook contact synchronization with address book server or services, people would think about exporting their contacts entries into vCard files (.vcf files), .csv files, .pst files, or Excel files. If you solely work with Outlook, then it is recommended to export them into .pst files for the best import result in the future. 

However, users most likely export Outlook contacts for use on other application or database import. The .csv method is not a good choice because foreign language characters in contacts will be corrupted after exporting. Thus, the best and the most compatible way to export is using vCard method.

Export Outlook contact to Excel

EVO staff has once again made some useful Outlook add-in after EVO Collaborator for Outlook. It is called Power Toys for Outlook. This collection of add-ins include a nice contact export tool for Outlook 2010, 2013, 2016, 2019. 

Export Outlook contact to Excel

There are 5 ways that PTO exports Outlook contacts:

1. Export contacts as vCards (Outlook VCARD 2.1) – This is as same as Outlook’s Save As except Outlook can only save one vCard per operation. PTO is able to save the whole contact folder at once.

2. Export contacts as vCards (VCARD 3.0) – This is the same as #1 except saving vCards as VCARD 3.0 format.

3. Export contacts into one single vCard (VCARD 3.0) – Since vCard protocol is able to store multiple contacts in one single file, PTO saves the hassle of managing 100s or even 1000s of vCard files.

4. Export contacts as Excel Document – PTO enables you to output all Outlook contacts into an Excel file for better viewing purpose with forking in nearly all commonly used fields in Outlook contact entries.

5. Export contacts into one vCard (for Thunderbird) – In reality, vCard files from Outlook have slight compatibility issues if you were to import them into Thunderbird. PTO does some final touches to perfect exported vCard files so the Thunderbird import would go smoothly as expected.

Here is a general guideline to export your Outlook contacts:

1. Download Power Toys for Outlook from EVO’s Official website.

2. Close Outlook and run setup.exe with administrator’s privilege.

3. Open Outlook and click on Power Toys ribbon at top.

4. Click on Export contacts.

5. Select your Outlook contact folder.

6. Click on 1 of 5 export types.

7. A folder created by date will pop up showing all vCard files accordingly.

As you can see, exporting Outlook contacts becomes as easy as 1-2-3.

How to auto BCC in Outlook?

At work, we write many emails every day. When some recipients should receive a carbon copy (CC), Outlook 2010, 2013, 2016, or 2019 provides a Rules and Alerts feature, which conducts an automated message forwarding to a list of people under certain conditions. However, this feature cannot fulfill our needs to send a blind carbon copy (BCC) to recipients who are not supposed to be reveled in the mail circulation.

To achieve this auto bcc task, we need to implement VBA codes or use a third-party Outlook add-in tool. I think it is too much a hassle to do the coding, so I would rather use an Outlook add-in. One of Power Toys for Outlook’s features is to auto bcc for you. 

It is quite simple and steps are as below:

1. Download Power Toys for Outlook from EVO’s Official website.

2. Close Outlook and run setup.exe with administrator’s privilege.

3. Open Outlook and click on Power Toys ribbon at top.

4. Click on Configure BCC rule.

5. Enter email address(es) under Automatically send BCC to Email addresses:

6. In fields next to From, To, Subject, Body and Attachment name, select operands among equals, not equals, contains one of, contains none of.

7. In fields next to operands, enter keywords for PTO to compare against.

8. Click on SAVE and QUIT.

This is an easy-to-use auto BCC tool. It is a pity that it only manages one rule. Hopefully, future updates will support multiple rules.

How to get Gmail push notification in Outlook?

Outlook enables users to create their Gmail accounts so they can receive emails on Outlook based on IMAP protocol. However, Outlook only checks emails for users every via a scheduled automatic send/receive feature. The shortest time gap is 1 minute.

Is there any way to deploy Gmail push mail notification under Outlook 2010, 2013, 2016 or 2019? 

Yes, there is! 

GGNotify from Power Toys for Outlook can check Gmail for you upon its arrival. 
Here is how:

1. Download Power Toys for Outlook from EVO’s Official website.

2. Close Outlook and run setup.exe with administrator’s privilege.

3. Open Outlook and click on Power Toys ribbon at top.

4. Click on Configure Gmail account.

5. Enter your Gmail account.

6. Click on Authorize Outlook to receive Gmail PUSH notification button to proceed OAuth.

7. Customize options below as stated.

8. Click on Save and Quit.

With this Outlook add-in, Gmail will not deliver mails late again in Outlook.

Configure Gmail account in Microsoft Outlook 2016 or 2019

Configure Gmail account in Microsoft Outlook 2016

Applies to: Outlook 2016, Outlook 2013, Outlook 2010, Outlook 2007, Gmail, Google Calendar, Google Task

For various reasons, we like to integrate Gmail accounts into Outlook rather than using Gmail on web browsers. At this point, we use free Gmail account as an example to demonstrate on how to create a Gmail account inside Outlook using IMAP and SMTP protocols.  

Adding Gmail account

Setting up Gmail account in Outlook can be as simple as a few steps below:

1. Click on [File] at top-left

2. Click on [+ Add Account]

3. Click on [E-mail Account] radial and fill in your name, E-mail Address and password. Then, click on [Next >] at lower-right

4. After 10 to 15 seconds of auto-discovery, your Gmail IMAP is successfully configured and click on [Finish] to exit [Add Account] window

5. At Navigation Pane to the left, you will see folders for your Gmail account

Unlike some on-premises mail server, whether they are free mail server or paid software that requires us to fill in server host name and supporting ports, Outlook is able to auto-detect Gmail configuration settings.

Managing subscribed folders

You can and you should take a look at the list of subscribed folders in your Gmail account, because you do not necessarily need to subscribe them all. For example, subscription to [Gmail]/All Mail folder can be omitted so that you can save a lot of time and bandwidth.

Streamline your Google experience in Outlook

For Outlook users who stick with Gmail accounts, it would be nice to also integrate their Google contacts, calendars and tasks from their Google accounts on Outlook. I personally recommend sync through Outlook add-ins. Since contacts, calendars and tasks are always changing all over the places, life is easier if things are synchronized throughout all your devices.

Surprisingly, it’s the year of 2016 and Gmail still doesn’t provide Push Mail Notification to Gmail account configured under Outlook. After observation for some time, the only way for me to be notified of new incoming mails for IMAP is if I leave the INBOX of my IMAP account selected.

Sync tools on the market

There are about a dozen of Outlook sync tools on the market, such as gSyncit, Companionlink, OggSync, Sync2, SyncMyCal and EVO Collaborator for Outlook. What if we want an all-in-one solution that synchronizes Google contacts and tasks while providing both real-time calendar sync and Gmail Push Mail to Outlook? EVO collaborator for outlook may be the only answer. I’d recommend Gmail users using Outlook as their default desktop mail client to try this add-in.

Error: Your browser is no longer supported . Upgrade and Install new...

Error: Your browser is no longer supported . Upgrade and Install new...

On 8/3/2016, I was playing my nVidia Shield and trying to log in my Google+ account. Then, I encountered an error message showing on GeForce Experience:

"Your browser is no longer supported . Upgrade and Install new one"

"이후 더 이상 지원되지 않는 브라우저 입니다. 최신 버전으로 업데이트 하세요 라는 문구가 뜨면서 인증을 계속 진행할 수 없는 상황입니다. "

I Googled this error message but found nothing about it. 

On the very same day, I was configuring EVO Collaborator for Outlook on my Outlook to sync my google contact, calendar and task with Microsoft Outlook. I met the same error message.

Your browser is not supported anymore.

 

Then, I contacted EVO staff regarding this matter. After a few hours, they replied me with a solution of a newer release along with an explanation:


Many PC software applications are written in Microsoft .Net Framework which is still using IE6 web browser control core. Under this environment, Google’s OAuth will think my IE browser is too old even though I am already on a Windows 10 with IE 8, 9, 10 or 11. Now, we came up with a solution to emulate the IE environment to persuade Google OAuth that it is already running a newer IE version.


After I downloaded the newer version, EVO Collaborator for Outlook is working properly with Google OAuth. Yet, EVO staff also told me that I can in fact use the .reg files included in the ECO package on other applications with the same issue by simply changing “outlook.exe” with executable file of applications that have the same issue. 


I was asking EVO staff if I can apply the same registry tweak on my GeForce case? They said, “Of course! Why not?” Then, I stuffed GeForce’s executable file called “GFExperience.EXE” in place of “Outlook.exe”. Amazingly, it works for my nVidia Shield. Thank you! EVO staff! You are wonderful!


By the way, here are what these two registries files look like: (one for XP and one for Windows 7-10):

• Windows 7-10:

Windows Registry Editor Version 5.00 

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION]"GFExperience.EXE"=dword:0000270f

• Windows XP:

Windows Registry Editor Version 5.00 

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION]"GFExperience.EXE"=dword:000022b8

How to sync Axigen Mail Server contacts in Outlook without Outlook connector via CardDAV?

How to sync Axigen contacts in Outlook without Outlook connector via CardDAV?

Among free mail server and paid server ware, if you are in IT industry for some time, you have probably heard of Axigen Mail Server. Its powerful features and scalability are proven to provide a decent alternative to Microsoft Exchange Server.

On the other day, when I saw EVO Collaborator for Outlook  was released and it supports synchronization with Axigen Mail Server's contacts or address book, I decided to try it out.

How to sync Axigen Mail Server contacts with Outlook using CardDAV protocol?

Once I got my trial installation of Axigen Mail Server done, all I did was opening my Outlook 2016 and manually entering contact URL in the following syntax:

https://<servername>/Contacts/

Then, I enter my full e-mail address and password. The next thing is clicking on TEST button, Apply button and Quit button.

As a result, the synchronization went successfully:

However, I notice that domain and public contacts are not yet to be synchronized through CardDAV.

I googled a little bit and found requests of implementing CalDAV and CardDAV support were brought up years back:

https://www.axigen.com/forum/forum/support-discussion-lists/feature-requests/3792-caldav-support

On Axigen's Google+ page, support for CardDAV was mentioned and made available back in Q2 2015.

https://plus.google.com/communities/102973968071431941505

Then, I found a good news on Axigen's Product Community update that CalDAV may be available in Q4 2016:

https://axigen.uservoice.com/forums/294255-general/suggestions/13322535-caldav-support

Many thanks to Axigen's R&D staffs on their effort making things possible. This is really awesome that users from Outlook 2019, 2016, 2010, 2013 and 2007 will benefit from it!