I want to migrate Outlook journal to excel including contact names

Status
Not open for further replies.
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
I would like to know how to migrate Outlook 2010 Journal fields into excel spreadsheet including the contact names.
using the Import/export fucntion, the conatct names, that are linked to the journal note, do not export.
Any special batch file to do?

Thanks for the help

François
 
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
I already did but in my note body there are several lines and the copy paste only gives me the firts line :(
I don't know how macro works though
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I'll see if i have a macro we can use. The other option (if it's a one time thing) is to export and copy - this will get you the full notes field and anything not exported. You'll need a unique field (usually the date/time) you can sort on to match the records.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I tweaked the code at http://www.slipstick.com/developer/code-samples/macro-export-outlook-fields-excel/ to use the journal entries.

Code:
Option Explicit
Sub CopyToExcel()
Dim xlApp As Object
Dim xlWB As Object
Dim xlSheet As Object
Dim rCount As Long
Dim bXStarted As Boolean
Dim enviro As String
Dim strPath As String
Dim currentExplorer As Explorer
Dim Selection As Selection
Dim olItem As Outlook.JournalItem
Dim obj As Object
Dim strColB, strColC, strColD, strColE, strColF, strColG, strColH       As String
               
' Get Excel set up
enviro = CStr(Environ("USERPROFILE"))
'the path of the workbook
strPath = enviro & "\Documents\test.xlsx"
     On Error Resume Next
     Set xlApp = GetObject(, "Excel.Application")
     If Err <> 0 Then
         Application.StatusBar = "Please wait while Excel source is opened ... "
         Set xlApp = CreateObject("Excel.Application")
         bXStarted = True
     End If
     On Error GoTo 0
     'Open the workbook to input the data
     Set xlWB = xlApp.Workbooks.Open(strPath)
     Set xlSheet = xlWB.Sheets("Sheet1")
    ' Process the message record
    
    On Error Resume Next
'Find the next empty line of the worksheet
rCount = xlSheet.Range("B" & xlSheet.Rows.Count).End(-4162).Row
' get the values from outlook
Set currentExplorer = Application.ActiveExplorer
Set Selection = currentExplorer.Selection
  For Each obj In Selection
    Set olItem = obj
   
'collect the fields
' journal
With olItem
    strColB = .Subject
    strColC = .Type
    strColD = .Body
    strColE = .Start
    strColF = .Duration
    strColG = .ContactNames
    strColH = .Categories
End With
'write them in the excel sheet
  xlSheet.Range("B" & rCount) = strColB
  xlSheet.Range("c" & rCount) = strColC
  xlSheet.Range("d" & rCount) = strColD
  xlSheet.Range("e" & rCount) = strColE
  xlSheet.Range("f" & rCount) = strColF
  xlSheet.Range("g" & rCount) = strColG
  xlSheet.Range("h" & rCount) = strColH
 
'Next row
  rCount = rCount + 1
Next
     xlWB.Close 1
     If bXStarted Then
         xlApp.Quit
     End If
    
     Set olItem = Nothing
     Set obj = Nothing
     Set currentExplorer = Nothing
     Set xlApp = Nothing
     Set xlWB = Nothing
     Set xlSheet = Nothing
End Sub
 
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Good morning Diana, Let me look at this and will get back to you. Thank you very much fo the help!
 
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Good morning Diane, it works great, thank you very much. There is one thing I did not realize though, some of my customers have the same exact name. Is there a way where I can add the Company name in another column. I used your codes and added lines for the Company and then tried with the spelling CompanyNames but nothing shows up. I'm trying to find out if that field has another name than what I see. Canb you help me out?
Regards,
 
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
here is what I tried but it gives me an error


Sub CopyToExcel()
Dim xlApp As Object
Dim xlWB As Object
Dim xlSheet As Object
Dim rCount As Long
Dim bXStarted As Boolean
Dim enviro As String
Dim strPath As String
Dim currentExplorer As Explorer
Dim Selection As Selection
Dim olItem As Outlook.JournalItem, contactItem
Dim obj As Object
Dim strColB, strColC, strColD, strColE, strColF, strColG, strColH, strColI, strColJ As String

' Get Excel set up
enviro = CStr(Environ("USERPROFILE"))
'the path of the workbook
strPath = enviro & "\Documents\testfp.xlsx"
On Error Resume Next
Set xlApp = GetObject(, "Excel.Application")
If Err <> 0 Then
Application.StatusBar = "Please wait while Excel source is opened ... "
Set xlApp = CreateObject("Excel.Application")
bXStarted = True
End If
On Error GoTo 0
'Open the workbook to input the data
Set xlWB = xlApp.Workbooks.Open(strPath)
Set xlSheet = xlWB.Sheets("Sheet1")
' Process the message record

On Error Resume Next
'Find the next empty line of the worksheet
rCount = xlSheet.Range("B" & xlSheet.Rows.Count).End(-4162).Row
' get the values from outlook
Set currentExplorer = Application.ActiveExplorer
Set Selection = currentExplorer.Selection
For Each obj In Selection
Set olItem = obj

'collect the fields
' journal
With olItem
strColB = .Subject
strColC = .Type
strColD = .Body
strColE = .Start
strColF = .Duration
strColG = .ContactNames
strColH = .Categories

'collect the fields
' contact

strColI = .CompanyNames
strColJ = .BusinessAddressPostalCode

End With
'write them in the excel sheet
xlSheet.Range("B" & rCount) = strColB
xlSheet.Range("c" & rCount) = strColC
xlSheet.Range("d" & rCount) = strColD
xlSheet.Range("e" & rCount) = strColE
xlSheet.Range("f" & rCount) = strColF
xlSheet.Range("g" & rCount) = strColG
xlSheet.Range("h" & rCount) = strColH
xlSheet.Range("i" & rCount) = strColI
xlSheet.Range("j" & rCount) = strColJ

'Next row
rCount = rCount + 1
Next
xlWB.Close 1
If bXStarted Then
xlApp.Quit
End If

Set olItem = Nothing
Set obj = Nothing
Set currentExplorer = Nothing
Set xlApp = Nothing
Set xlWB = Nothing
Set xlSheet = Nothing
End Sub
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
use .companies, not .companynames, to grab the company field.
 
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Hi,
Thanks for the feedback, I really appreciate your help. I will get back to you shortly
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
D Outlook 2016 Migrate 'On My Computer' (local storage) Calendar from Mac Outlook to Exchange Account Using Outlook 5
B Migrate Outlook 2007 to Office 365 Using Outlook 3
T Migrate POP3 Folders and Emails to outlook.com via Outlook 2013 Using Outlook.com accounts in Outlook 2
J migrate outlook mail folders from user's old workstation to their new pc Using Outlook 6
T Items in MSN Hotmail inbox will not migrate to Outlook inbox Using Outlook 2
R Migrate Mac Outlook 2011 to PC outlook 2010 Using Outlook 2
J Too many email folders on MSN issue. Migrate to Outlook? Using Outlook 3
S Configure outlook client after migrate mailbox from exchange 2003 to 2010 Exchange Server Administration 3
F A new Profile did not migrate the folders into Office Outlook 2010 from HotMail Using Outlook 4
M Method to migrate OE personal folders to Outlook PSTs? Using Outlook 2
M Need help to migrate Outlook to a new User Profile in XP Using Outlook 1
C How to migrate e-mails from Outlook 2000 to Outlook 2010 Beta without a server, from a local machine? Using Outlook 1
J Migrate from godaddy 365 to office 365 home Using Outlook 8
P Migrate Office 365 mailbox to a different on-premises domain Using Outlook 1
T OL BCM 2007 - Possible to migrate SQL Server Express 2012 ? BCM (Business Contact Manager) 2
A windows 2003 server with exchange2003 server migrate to windows 2008 std with exchange server 2010 Exchange Server Administration 1
J Migrate from SBS 2008 to Windows Server 2008 R2 (Exchange 2010) Exchange Server Administration 8
L Exchange 2003 on SBS to migrate Exchange 2010 Exchange Server Administration 2
M Public Folders Not Replicating Between Exchange 2007 and 2010 (Migrate/Transitioning 2007 to 2010) Exchange Server Administration 6
P Trying to migrate email from PST to Hotmail; large emails break the connector with 'Network operation failed' Using Outlook 3
E Migrate exchange 2007 to a new server with exchange 2010 Exchange Server Administration 2
R Migrate Exchange 2003 to Exchange 2007 Cross-Forest Exchange Server Administration 4
J Migrate Exchange 2010 to another server Exchange Server Administration 3
M migrate from exchange 2003 to 2010 Exchange Server Administration 6
A CAS Proxying with Active Sync when migrate from Exchange 2007 to 2010 Exchange Server Administration 1
P migrate mailbox from exchange 2003 to exchange 2010 Exchange Server Administration 11
R migrate resources Exchange Server Administration 1
B Migrate from 2000 to 2010 without upgrade? Exchange Server Administration 1
V Mailbox Size after Migrate 2003 to 2010 Exchange Server Administration 10
N Can I migrate Exchange 2007 's mailboxes in A domain to the trusted B domain ? Exchange Server Administration 3
S Exchange 2003 to Exchange 2010 migrate Exchange Server Administration 7
S Migrate from Exchange 2007 to 2010 and use existing SAN certificate Exchange Server Administration 11
S Migrate Public Folder (Exchange 2007 --&gt; Exchange 2010) Exchange Server Administration 8
X How to migrate from two Exchange 2003 servers to one Exchange 2010 serving two currently independent AD domains Exchange Server Administration 2
M Migrate from Exchange 2007 to Exchange 2010 Exchange Server Administration 3
F Exchange 2010 -Powershell to migrate 2003 users to 2010? Exchange Server Administration 2
A Migrate Public Folders from EX2003 to EX2010 Server Exchange Server Administration 7
P How to migrate existing Exchange 2010 to new server with different computer name. Exchange Server Administration 14
D Exchange 2010 cannot migrate mailbox for exchange 2003 Exchange Server Administration 2
S migrate policies/OAB from exchange 2007 to exchange 2010 Exchange Server Administration 3
W How to migrate mailboxes from Postfix v 2.5.5 to Exchange 2010 Exchange Server Administration 3
D Migrate from Zimbra to Exchange 2010 Exchange Server Administration 4
F Migrate from GroupWise System Exchange Server Administration 4
P Migrate profile - cached mode setting Using Outlook 2
C Migrate Exchange 2003 to Exchange 2010 (Resource Forest) Exchange Server Administration 11
K Migrate FROM Exchange 2010 to Exchange 2007? Exchange Server Administration 2
S Migrate users and mailboxes from 2003 sbs to 2008 R2 Enterprise? Exchange Server Administration 3
M Migrate Exchange 2000 Data To Exchange 2010 Exchange Server Administration 5
T Is it possible to migrate from exchange 2003 directly to 2010? Exchange Server Administration 13
V Upgraded Outlook Using Outlook 0
Similar threads


















































Top