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/ ) :
- We need to configure Outlook to download all email from server: File – Account settings – Change – Keep offline: All
- Restart Outlook and wait some time to allow downloading mails from server.
- Click on ‘File’, ‘Import and Export’ to open the Wizard
- Select ‘Export to a File’ [then click Next]
- Select CSV file [click Next]
- Select Sent folder [Next]
- Click on Browse to select a location and then type the file name to export the information to (terminated by .xls) [Next]
- Click on Map Custom Fields. This will bring up a list of all the available fields that are available in that folder.
- 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 list
- Click OK
- Click Finish
- 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.
- Select Unique recordsonly and OK.
- I need to remove local users as well. Using Find and Replace feature, in column B we find all cells contains “/o” substring.
- 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.
- ALTER DATABASE DatabaseName SET OFFLINE;
- Move .mdf and .ldf files to new directory.
- ALTER DATABASE DatabaseName MODIFY FILE ( NAME = DatabaseName, FILENAME = ‘C:\DBs\DatabaseName.mdf’ );
- ALTER DATABASE DatabaseName MODIFY FILE ( NAME = DatabaseName_Log, FILENAME = ‘C:\DBs\DatabaseName_Log.ldf’ );
- ALTER DATABASE DatabaseName SET ONLINE;
Original MS Article: https://msdn.microsoft.com/en-us/library/ms345483.aspx
Export from Office 365
- Exchange admin cemter – compliance management – in-place eDiscovery & hold:
- Click “+” to create a new search
- Type some name:
- With Specify mailboxes to search click on “+” and find particular user:
- Leave Include all content selected and click Next
- Do not select Place content … on hold, click Finish
- When Search is saved, select it and click Export to PST button
- When eDiscovery PST Export Tool launched, select proper location to your PST file.
Import to Google Apps
- Download Google Apps Migration for Microsoft Outlook from here:
- Since organization admin doesn’t have access to users email boxes, You need to have user password.
- Start migration:
- Allow access of this tool to mail box:
- Change source to migrate to PST:
- On step 2 select what data to migrate:
- Migration started:
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
The solution is to disable this code.
From editor – Form properties – in Event Handlers find related Library – Open to edit and remove Enabled checkbox.
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
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: email@example.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