Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bokeltri
 
Posts: n/a
Default Can I create a static link between Excel and Outlook contact data.

I have contact information in my excel spreadsheet that I update manually. I
would like to link these fields to my Outlook cantact data instead. Can this
be done and how?
  #2   Report Post  
galimi
 
Posts: n/a
Default

You can link to data in Outlook from Excel using VBA and navigating through
the Outlook Object Model.

I have posted an example file to http://www.Galimi.com/Examples/Outlook.xls

Following is the code that should be enough to complete what you wish to
accomplish:

http://HelpExcel.com

Sub getOutlook()
Set myOLAPP = CreateObject("Outlook.Application")
'Dim myOLAPP As New Outlook.Application


Set mynamespace = myOLAPP.GetNamespace("MAPI")
Set myAddressList = mynamespace.Folders(1).Folders(6).Items

For Each strItem In myAddressList
shtImport.Range("a2").Offset(r) = strItem.FirstName
shtImport.Range("b2").Offset(r) = strItem.LastName
r = r + 1

Next


Set oOL = Nothing
End Sub


"Bokeltri" wrote:

I have contact information in my excel spreadsheet that I update manually. I
would like to link these fields to my Outlook cantact data instead. Can this
be done and how?

  #3   Report Post  
Bokeltri
 
Posts: n/a
Default

Something isn't working correctly in the example spreadsheet. (1) When I
open your sreadsheet, there is a complie error for the Macro adveriseME. The
"ie =" is highlighted and the message is "can't find project or library". (2)
when I run GetOutlook the "MyOlapp =" is highlighted and the error says can't
find project or library. Any suggestions?


"galimi" wrote:

You can link to data in Outlook from Excel using VBA and navigating through
the Outlook Object Model.

I have posted an example file to http://www.Galimi.com/Examples/Outlook.xls

Following is the code that should be enough to complete what you wish to
accomplish:

http://HelpExcel.com

Sub getOutlook()
Set myOLAPP = CreateObject("Outlook.Application")
'Dim myOLAPP As New Outlook.Application


Set mynamespace = myOLAPP.GetNamespace("MAPI")
Set myAddressList = mynamespace.Folders(1).Folders(6).Items

For Each strItem In myAddressList
shtImport.Range("a2").Offset(r) = strItem.FirstName
shtImport.Range("b2").Offset(r) = strItem.LastName
r = r + 1

Next


Set oOL = Nothing
End Sub


"Bokeltri" wrote:

I have contact information in my excel spreadsheet that I update manually. I
would like to link these fields to my Outlook cantact data instead. Can this
be done and how?

  #4   Report Post  
galimi
 
Posts: n/a
Default

In the project, set a reference for Outlook or replace

dim ie as new Outlook

with

set ie = createobject("Outlook.Application")

The latter will allow you to connect to Outlook without setting a reference

http://HelpExcel.com

"Bokeltri" wrote:

Something isn't working correctly in the example spreadsheet. (1) When I
open your sreadsheet, there is a complie error for the Macro adveriseME. The
"ie =" is highlighted and the message is "can't find project or library". (2)
when I run GetOutlook the "MyOlapp =" is highlighted and the error says can't
find project or library. Any suggestions?


"galimi" wrote:

You can link to data in Outlook from Excel using VBA and navigating through
the Outlook Object Model.

I have posted an example file to http://www.Galimi.com/Examples/Outlook.xls

Following is the code that should be enough to complete what you wish to
accomplish:

http://HelpExcel.com

Sub getOutlook()
Set myOLAPP = CreateObject("Outlook.Application")
'Dim myOLAPP As New Outlook.Application


Set mynamespace = myOLAPP.GetNamespace("MAPI")
Set myAddressList = mynamespace.Folders(1).Folders(6).Items

For Each strItem In myAddressList
shtImport.Range("a2").Offset(r) = strItem.FirstName
shtImport.Range("b2").Offset(r) = strItem.LastName
r = r + 1

Next


Set oOL = Nothing
End Sub


"Bokeltri" wrote:

I have contact information in my excel spreadsheet that I update manually. I
would like to link these fields to my Outlook cantact data instead. Can this
be done and how?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I link to an Outlook public folder from an Excel spreadshe. DJBaker Excel Discussion (Misc queries) 0 January 28th 05 08:35 PM
export excel file to outlook express contact list gebhardt family New Users to Excel 0 January 21st 05 12:59 AM
Translaton Error when importing Excel data into Outlook? duckeywest Excel Discussion (Misc queries) 0 January 19th 05 01:29 AM
Accessing Outlook from Excel Chaplain Doug Excel Discussion (Misc queries) 0 December 20th 04 12:39 AM
Excel client list in to Outlook shann18 Excel Discussion (Misc queries) 1 December 18th 04 02:14 AM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"