Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   Export Single contact into excel (http://www.outlookbanter.com/outlook-using-contacts/77492-export-single-contact-into-excel.html)

phil August 24th 08 03:38 PM

Export Single contact into excel
 
Hi I use outlook 2003 to manage my business contacts. It's great. I use excel
to do invoives and quotes. I want ot be able to have outlook put teh clients
contact info into teh right cells in excel, like name: address, phone, etc.
all that data into the excel spreadsheet without me having to re type it.

Any info would be usefuk, thanks.

Diane Poremsky [MVP] August 24th 08 04:38 PM

Export Single contact into excel
 
I don't know of any easy way to do a merge or export to do a single item-
but if copy and paste is acceptable, see
http://www.slipstick.com/Tutorials/copyto/excel.htm. Otherwise you might be
able to use VBA to pull it into the fields.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Phil" wrote in message
...
Hi I use outlook 2003 to manage my business contacts. It's great. I use
excel
to do invoives and quotes. I want ot be able to have outlook put teh
clients
contact info into teh right cells in excel, like name: address, phone,
etc.
all that data into the excel spreadsheet without me having to re type it.

Any info would be usefuk, thanks.



Diane Poremsky [MVP] August 24th 08 04:43 PM

Export Single contact into excel
 
Also, see http://www.slipstick.com/Tutorials/l...omcontacts.htm

"Diane Poremsky [MVP]" wrote in message
...
I don't know of any easy way to do a merge or export to do a single item-
but if copy and paste is acceptable, see
http://www.slipstick.com/Tutorials/copyto/excel.htm. Otherwise you might
be able to use VBA to pull it into the fields.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Phil" wrote in message
...
Hi I use outlook 2003 to manage my business contacts. It's great. I use
excel
to do invoives and quotes. I want ot be able to have outlook put teh
clients
contact info into teh right cells in excel, like name: address, phone,
etc.
all that data into the excel spreadsheet without me having to re type it.

Any info would be usefuk, thanks.




All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com