Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - General Queries (http://www.outlookbanter.com/outlook-general-queries/)
-   -   addreeses (http://www.outlookbanter.com/outlook-general-queries/45450-addreeses.html)

Oggy April 7th 07 02:35 PM

addreeses
 
Hi

Can anyone please advise me how i can insert a name and address from
the microsoft address book into a exel spreadsheet. If this cannot be
done what alternitives are there?

Thanks

Oggy


Russ Valentine [MVP-Outlook] April 7th 07 02:54 PM

addreeses
 
Explain what you mean by the "microsoft address book." There is no such
thing. Explain more clearly what you are trying to do. Are you trying to
parse the individual Contact fields into separate cells?
--
Russ Valentine
[MVP-Outlook]
"Oggy" wrote in message
ups.com...
Hi

Can anyone please advise me how i can insert a name and address from
the microsoft address book into a exel spreadsheet. If this cannot be
done what alternitives are there?

Thanks

Oggy




Oggy April 7th 07 03:30 PM

addreeses
 
On 7 Apr, 13:54, "Russ Valentine [MVP-Outlook]"
wrote:
Explain what you mean by the "microsoft address book." There is no such
thing. Explain more clearly what you are trying to do. Are you trying to
parse the individual Contact fields into separate cells?
--
Russ Valentine
[MVP-Outlook]"Oggy" wrote in message

ups.com...



Hi


Can anyone please advise me how i can insert a name and address from
the microsoft address book into a exel spreadsheet. If this cannot be
done what alternitives are there?


Thanks


Oggy- Hide quoted text -


- Show quoted text -


Yes, i am trying to insert from a list a contact from Outlook and put
it into a spreadsheet. I have tried loading the contacts into a
userform list but as there are over 1000 contacts it takes a while to
load.

In Word you can get the addresses easy and quickly, but its through
the envelope and labels tools and it puts the selected address onto a
envelope. What i am looking for is a similar tool that will put the
selcted info into a spreadsheet, IE name, address, telephone number,
etc...

Do you have any ideas?

Thanks



Russ Valentine [MVP-Outlook] April 7th 07 03:50 PM

addreeses
 
Excel has no Insert Address function. Why would not just export your
Contacts to Excel?
--
Russ Valentine
[MVP-Outlook]
"Oggy" wrote in message
ups.com...
On 7 Apr, 13:54, "Russ Valentine [MVP-Outlook]"
wrote:
Explain what you mean by the "microsoft address book." There is no such
thing. Explain more clearly what you are trying to do. Are you trying to
parse the individual Contact fields into separate cells?
--
Russ Valentine
[MVP-Outlook]"Oggy" wrote in message

ups.com...



Hi


Can anyone please advise me how i can insert a name and address from
the microsoft address book into a exel spreadsheet. If this cannot be
done what alternitives are there?


Thanks


Oggy- Hide quoted text -


- Show quoted text -


Yes, i am trying to insert from a list a contact from Outlook and put
it into a spreadsheet. I have tried loading the contacts into a
userform list but as there are over 1000 contacts it takes a while to
load.

In Word you can get the addresses easy and quickly, but its through
the envelope and labels tools and it puts the selected address onto a
envelope. What i am looking for is a similar tool that will put the
selcted info into a spreadsheet, IE name, address, telephone number,
etc...

Do you have any ideas?

Thanks





Oggy April 7th 07 04:07 PM

addreeses
 
On 7 Apr, 14:50, "Russ Valentine [MVP-Outlook]"
wrote:
Excel has no Insert Address function. Why would not just export your
Contacts to Excel?
--
Russ Valentine
[MVP-Outlook]"Oggy" wrote in message

ups.com...



On 7 Apr, 13:54, "Russ Valentine [MVP-Outlook]"
wrote:
Explain what you mean by the "microsoft address book." There is no such
thing. Explain more clearly what you are trying to do. Are you trying to
parse the individual Contact fields into separate cells?
--
Russ Valentine
[MVP-Outlook]"Oggy" wrote in message


roups.com...


Hi


Can anyone please advise me how i can insert a name and address from
the microsoft address book into a exel spreadsheet. If this cannot be
done what alternitives are there?


Thanks


Oggy- Hide quoted text -


- Show quoted text -


Yes, i am trying to insert from a list a contact from Outlook and put
it into a spreadsheet. I have tried loading the contacts into a
userform list but as there are over 1000 contacts it takes a while to
load.


In Word you can get the addresses easy and quickly, but its through
the envelope and labels tools and it puts the selected address onto a
envelope. What i am looking for is a similar tool that will put the
selcted info into a spreadsheet, IE name, address, telephone number,
etc...


Do you have any ideas?


Thanks- Hide quoted text -


- Show quoted text -


If i export my contacts from Outlook, i then have two databases of
contacts to keep up to date and manage.

Thanks for looking into this for me



All times are GMT +1. The time now is 09:06 AM.

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