Pushing Data From Outlook 2003 to Excel 2003

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

jiffle

Thread Starter
Joined
Oct 26, 2007
Messages
3
Hi there,
I want to push specific data from a selected contact in Outlook 2003 to a predefined Excel 2003 spreadsheet. The scenario is that I want a naive user to enter data into a new contact in outlook be able to push a button and insert that data into a quotation that exists as a excel file. The data that I am interested in moving includes.

Title
First name
Last Name
Company
Address Fields
Telephone Number

I have already created the spreadsheet based Quotation form in a file called Quote.xls. I have not named the individual cells at present just having the Name in Cell B1 The company in B2 and the address fields in B3 to B7.

I have done some macro and VBA programming in Excel, but have little or no experience in using Outlook macros.

Any help/suggestions/solutions gratefully received.

Regards

Michael
 

jimr381

Jim
Joined
Jul 20, 2007
Messages
4,193
Have you looked into turning on the smarttags within Excel. One of them will tie into Outlook's address book and pull back data. To access the options try "Tools">>"AutoCorrect Options">>"Smarttags" tab and check off the items that you want active. I do not recall if the Persona Name one will add the address information like it does in Word though.

You could also try the Data Push add-in here. I cannot download it and install it, but let me know if it helps you out.
 

jiffle

Thread Starter
Joined
Oct 26, 2007
Messages
3
Jim,
thanks for this idea, I will investigate it further, however from an initial look this seems to be driven from Excel rather than from Outlook which is what I am trying to acheive.

once again thanks for your help.

Michael
 
Joined
Oct 10, 2007
Messages
33
There's an export to a file function in Outlook; that would get you part way there. Then when you open excel, it could look for the file????
lika2know
 

jiffle

Thread Starter
Joined
Oct 26, 2007
Messages
3
Thank you for your reply. I have used the export function in Outlook. However, I think that it creates a new file and puts the data in sequential cells starting say in A1. What I want to do is use an existing file and put the data in predefined non sequential files
 
Joined
Jul 25, 2004
Messages
5,458
Hi, you're either going to need VB to create an Outlook add-in or use Excel or VBS to consolidate your Excel exported files. The VB route would be more difficult (IMHO). Let us know if you'd like to do the Excel route. If so, give us details as to where your files will be located, a sample of an exported file, and how you want your data consolidated (i.e. data structure, sheet to put on, where workbook will be held, etc).
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top