Export all email addresses from Sent Outlook folder

Here is procedure how to export all email addresses from Sent Outlook folder to Excel ( I found the idea here https://superuser.com/questions/50006/how-can-i-export-all-email-addresses-i-have-sent-to-from-outlook-or-any-other-em/ ) :

  1. We need to configure Outlook to download all email from server: File – Account settings – Change – Keep offline: All

Download all mails from Exchange server

  1. Restart Outlook and wait some time to allow downloading mails from server.
  2. Click on ‘File’, ‘Import and Export’ to open the Wizard
  3. Select ‘Export to a File’ [then click Next]
  4. Select CSV file [click Next]
  5. Select Sent folder [Next]
  6. Click on Browse to select a location and then type the file name to export the information to (terminated by .xls) [Next]
  7. Click on Map Custom Fields. This will bring up a list of all the available fields that are available in that folder.
  8. Since we are only interested in Email address, click on Clear Mapand then from the Left side click on From: (address) and To: (Name) and drag that to the Right listExport email custom filter
  9. Click OK
  10. Click Finish
  11. Now we have Excel file with all contacted email addresses. There are a lot of duplicates. Click on A column to select it and on theDatatab, in the Sort & Filter group, click Advanced.
  12. Select Unique recordsonly and OK.
    Excel advanced filter
  1. I need to remove local users as well. Using Find and Replace feature, in column B we find all cells contains “/o” substring.Removing local addresses


  2. Once it finishes Ctrl/A to select all found, right click on one of the selected row on the sheet and choose “Delete row”.


Now we have Excel file with recipients addresses you contacted since you have your mail box.


Posted in Short notes | Tagged , , , , | Leave a comment

Change location of SQL database files

  2. Move .mdf and .ldf files to new directory.
  3. ALTER DATABASE DatabaseName MODIFY FILE ( NAME = DatabaseName, FILENAME = ‘C:\DBs\DatabaseName.mdf’ );
  4. ALTER DATABASE DatabaseName MODIFY FILE ( NAME = DatabaseName_Log, FILENAME = ‘C:\DBs\DatabaseName_Log.ldf’ );

Original MS Article: https://msdn.microsoft.com/en-us/library/ms345483.aspx


Posted in Short notes | Tagged | Leave a comment

Migrate mailbox from Office 365 to Google Apps

Export from Office 365

  1. Exchange admin cemter – compliance management – in-place eDiscovery & hold:

Migration 1

  1. Click “+” to create a new search
  2. Type some name:

migrate 2

  1. With Specify mailboxes to search click on “+” and find particular user:


  1. Leave Include all content selected and click Next
  2. Do not select Place content … on hold, click Finish
  3. When Search is saved, select it and click Export to PST button
  4. When eDiscovery PST Export Tool launched, select proper location to your PST file.

Import to Google Apps

  1. Download Google Apps Migration for Microsoft Outlook from here:


  1. Since organization admin doesn’t have access to users email boxes, You need to have user password.
  2. Start migration:


  1. Allow access of this tool to mail box:

migrate 45

  1. Change source to migrate to PST:

migrate 5

  1. On step 2 select what data to migrate:

migrate 6

  1. Migration started:migr7
Posted in Short notes | Tagged , , , | Leave a comment

unable to get value of the property “setVisible” in Dynamics CRM

One day our marketing changed the lead form in Dynamics CRM online. Then we start receiving following popup error:
There was an error with this field’s customized event.
Error:Unable to get property ‘setVisible’ of undefined or null reference

This is because of custom JavaScript code added to this form. The code should change the fields removed by our guy.

The solution is to disable this code.

From editor – Form properties – in Event Handlers find related Library – Open to edit and remove Enabled checkbox.


Posted in Short notes | Tagged , | Leave a comment

Export SQL table to Excel

Following script will export 50% of some SQL table to local Excel file:

declare @sql varchar(8000)
set @sql=’exec master..xp_cmdshell ”bcp “SELECT TOP 50 PERCENT column1,column2,column3 from [Database-name].dbo.Table-name ORDER BY column1 ASC” queryout “C:\data_file1.xls” -T -c”’

To export second half – change ASC to DESC.

Same procedure from CMD:

bcp “SELECT TOP 50 PERCENT column1,column2,column3 from [Database-name].dbo.Table-name ORDER BY column11 DESC” queryout “C:\data_file5.xls” -T -c

Posted in Short notes | Tagged | Leave a comment

Add subdomain to federated Office 365 domain

One day I need to add subdomain to our domain.com for marketing email management. We are using Office 365 federated with our on premise AD and our public DNS hosted by third party service provider.
Below is PowerShell comands that have to be executed on a machine running Federation Services. Run Microsoft Online Services Module for Windows PowerShell and execute following:
PS C:\Windows\system32> Import-Module msonline
PS C:\Windows\system32> $cred = Get-Credential
Credentials should be provided as following: username@domain.com and your AD password.
PS C:\Windows\system32> Connect-MsolService -cred $cred
PS C:\Windows\system32> Get-Command *msol*
PS C:\Windows\system32> New-MsolFederatedDomain -DomainName subdomain.domain.com

Posted in Short notes | Tagged , , | Leave a comment

FortiClient SSLVPN Stops at 98% on Windows 7 X64

Found error message “The error code returned on failure is 633” in Event Viewer. Uninstalled FortiClient, disabled IP V6 on the network adapter, rebooted and installed client again. It solved the problem!

Mindaugo blogas


I had a problem with VPN connecting to client from your Windows 7 64bit machine. The connection just stops (hangs) at 98%  (percent), then after a few seconds disconnects.

In the Forti server logs we saw, that I just had started session and disconnected.

Google didn’t help.

The solution is to disable IP6 protocol in network connections menu – on your physical network adapter. Then don’t forget to RESTART your computer.



Some related error messages from Event Viewer

CoId={2759D407-FF7A-4B2F-89EF-49D288D9DD7E}: The user SYSTEM dialed a connection named fortissl which has terminated. The reason code returned on termination is 631.

CoId={E6310774-BA75-4860-A754-4F2C414E70C1}: The user SYSTEM dialed a connection named fortissl which has failed. The error code returned on failure is 633.

CoId={12EA93EE-2A00-4FAE-BF84-0564B2F2ADB8}: The user SYSTEM dialed a connection named fortissl which has failed. The error code returned on failure is 680.

View original post

Posted in Short notes | 2 Comments