A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Import formatted label list into Outlook Contacts



 
 
Thread Tools Display Modes
  #1  
Old June 5th, 2009, 06:38 PM posted to microsoft.public.outlook.contacts
Juanbal
external usenet poster
 
Posts: 6
Default Import formatted label list into Outlook Contacts

We maintain a modest 1000 records/contacts for the specific purpose of
mailing news letters. These contacts were mistakingly added to another more
extensive list of contacts. In order to reintegrate these to our original
newsletter list we will need to do it "by hand." We do have a merged-labels
file containing all of the contacts in question.

Is there a way to automatically take these labels and recreate the contact
group in outlook?
  #2  
Old June 5th, 2009, 08:27 PM posted to microsoft.public.outlook.contacts
Brian Tillman [MVP - Outlook]
external usenet poster
 
Posts: 10,888
Default Import formatted label list into Outlook Contacts

"Juanbal" wrote in message
...

We maintain a modest 1000 records/contacts for the specific purpose of
mailing news letters. These contacts were mistakingly added to another more
extensive list of contacts. In order to reintegrate these to our original
newsletter list we will need to do it "by hand." We do have a merged-labels
file containing all of the contacts in question.

Is there a way to automatically take these labels and recreate the contact
group in outlook?


What's a Contact "group"? Outlook uses no such term. Perhaps you mean a
Contact folder or perhaps you mean a Distribution List. Only you know the
answer to that.
--
Brian Tillman [MVP-Outlook]

  #3  
Old June 5th, 2009, 08:30 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 1,106
Default Import formatted label list into Outlook Contacts

Unclear post.
Clarify what you mean by a "contacts list." Outlook uses no such term.
Clarify what you mean by "a merged-labels file"

--
Russ Valentine
[MVP-Outlook]
"Juanbal" wrote in message
...
We maintain a modest 1000 records/contacts for the specific purpose of
mailing news letters. These contacts were mistakingly added to another
more
extensive list of contacts. In order to reintegrate these to our original
newsletter list we will need to do it "by hand." We do have a
merged-labels
file containing all of the contacts in question.

Is there a way to automatically take these labels and recreate the contact
group in outlook?


  #4  
Old June 6th, 2009, 02:30 PM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Import formatted label list into Outlook Contacts

file, import to make separate contacts or see
http://slipstick.com/Tutorials/create/dl.asp to add them to a DL.

--
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.


"Juanbal" wrote in message
...
We maintain a modest 1000 records/contacts for the specific purpose of
mailing news letters. These contacts were mistakingly added to another
more
extensive list of contacts. In order to reintegrate these to our original
newsletter list we will need to do it "by hand." We do have a
merged-labels
file containing all of the contacts in question.

Is there a way to automatically take these labels and recreate the contact
group in outlook?


  #5  
Old June 9th, 2009, 05:23 PM posted to microsoft.public.outlook.contacts
Juanbal
external usenet poster
 
Posts: 6
Default Import formatted label list into Outlook Contacts

My apologies. I do mean a Contact Folder or subfolder in this case, but not
a distribution list.
--
Juanbal


"Brian Tillman [MVP - Outlook]" wrote:

"Juanbal" wrote in message
...

We maintain a modest 1000 records/contacts for the specific purpose of
mailing news letters. These contacts were mistakingly added to another more
extensive list of contacts. In order to reintegrate these to our original
newsletter list we will need to do it "by hand." We do have a merged-labels
file containing all of the contacts in question.

Is there a way to automatically take these labels and recreate the contact
group in outlook?


What's a Contact "group"? Outlook uses no such term. Perhaps you mean a
Contact folder or perhaps you mean a Distribution List. Only you know the
answer to that.
--
Brian Tillman [MVP-Outlook]


  #6  
Old June 9th, 2009, 05:38 PM posted to microsoft.public.outlook.contacts
Juanbal
external usenet poster
 
Posts: 6
Default Import formatted label list into Outlook Contacts

I mean a contact folder. By merged label file I mean a Word Doc file that
contains the 1000 contacts formatted as labels and ready to be printed as
labels to affix to the newsletters for regular USPS mail. Each label in that
file represents an individual contact: Name, company, address, city, state
and zip code. My question: is there a way that I can use the information on
each one of those labels and recreate the contacts in "Outlook contacts?"
--
Juanbal


"Russ Valentine [MVP-Outlook]" wrote:

Unclear post.
Clarify what you mean by a "contacts list." Outlook uses no such term.
Clarify what you mean by "a merged-labels file"

--
Russ Valentine
[MVP-Outlook]
"Juanbal" wrote in message
...
We maintain a modest 1000 records/contacts for the specific purpose of
mailing news letters. These contacts were mistakingly added to another
more
extensive list of contacts. In order to reintegrate these to our original
newsletter list we will need to do it "by hand." We do have a
merged-labels
file containing all of the contacts in question.

Is there a way to automatically take these labels and recreate the contact
group in outlook?



  #7  
Old June 9th, 2009, 05:39 PM posted to microsoft.public.outlook.contacts
Juanbal
external usenet poster
 
Posts: 6
Default Import formatted label list into Outlook Contacts

Thank you Diane for the resources. I will look and see and get back if I
find any thing.
--
Juanbal


"Diane Poremsky [MVP]" wrote:

file, import to make separate contacts or see
http://slipstick.com/Tutorials/create/dl.asp to add them to a DL.

--
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.


"Juanbal" wrote in message
...
We maintain a modest 1000 records/contacts for the specific purpose of
mailing news letters. These contacts were mistakingly added to another
more
extensive list of contacts. In order to reintegrate these to our original
newsletter list we will need to do it "by hand." We do have a
merged-labels
file containing all of the contacts in question.

Is there a way to automatically take these labels and recreate the contact
group in outlook?


  #8  
Old June 9th, 2009, 10:07 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 1,106
Default Import formatted label list into Outlook Contacts

At the time you create a merge document, you can save it as a document to be
reused if you want. You'd need to post in a Word group if you need more
details.
--
Russ Valentine
[MVP-Outlook]
"Juanbal" wrote in message
...
I mean a contact folder. By merged label file I mean a Word Doc file that
contains the 1000 contacts formatted as labels and ready to be printed as
labels to affix to the newsletters for regular USPS mail. Each label in
that
file represents an individual contact: Name, company, address, city, state
and zip code. My question: is there a way that I can use the information
on
each one of those labels and recreate the contacts in "Outlook contacts?"
--
Juanbal


"Russ Valentine [MVP-Outlook]" wrote:

Unclear post.
Clarify what you mean by a "contacts list." Outlook uses no such term.
Clarify what you mean by "a merged-labels file"

--
Russ Valentine
[MVP-Outlook]
"Juanbal" wrote in message
...
We maintain a modest 1000 records/contacts for the specific purpose of
mailing news letters. These contacts were mistakingly added to another
more
extensive list of contacts. In order to reintegrate these to our
original
newsletter list we will need to do it "by hand." We do have a
merged-labels
file containing all of the contacts in question.

Is there a way to automatically take these labels and recreate the
contact
group in outlook?




  #9  
Old June 10th, 2009, 04:44 PM posted to microsoft.public.outlook.contacts
Juanbal
external usenet poster
 
Posts: 6
Default Import formatted label list into Outlook Contacts

I am not making myself clear. One more try.
1.) I had a Contacts folder with a thousand contacts.
2.) I merged these contacts into a Word document containing the one thousand
contacts.
3.) Subsequent to this merge, we inadvertently deleted (for the sake of
argument) all one thousand contacts from the Contacts folder.
4.) Now, all we have is the merged document containing the contacts.
5.) We can cut and paste unto outlook contacts one by one; or is there an
easier way to do this that would not require such labor intensive effort?

I apologize for expressing myself this way. I truly do appreciate your
effort Russ. If we have to do it "by hand" so be it. I was looking for an
easier way of doing it.

Thank you again.

--
Juanbal


"Russ Valentine [MVP-Outlook]" wrote:

At the time you create a merge document, you can save it as a document to be
reused if you want. You'd need to post in a Word group if you need more
details.
--
Russ Valentine
[MVP-Outlook]
"Juanbal" wrote in message
...
I mean a contact folder. By merged label file I mean a Word Doc file that
contains the 1000 contacts formatted as labels and ready to be printed as
labels to affix to the newsletters for regular USPS mail. Each label in
that
file represents an individual contact: Name, company, address, city, state
and zip code. My question: is there a way that I can use the information
on
each one of those labels and recreate the contacts in "Outlook contacts?"
--
Juanbal


"Russ Valentine [MVP-Outlook]" wrote:

Unclear post.
Clarify what you mean by a "contacts list." Outlook uses no such term.
Clarify what you mean by "a merged-labels file"

--
Russ Valentine
[MVP-Outlook]
"Juanbal" wrote in message
...
We maintain a modest 1000 records/contacts for the specific purpose of
mailing news letters. These contacts were mistakingly added to another
more
extensive list of contacts. In order to reintegrate these to our
original
newsletter list we will need to do it "by hand." We do have a
merged-labels
file containing all of the contacts in question.

Is there a way to automatically take these labels and recreate the
contact
group in outlook?




  #10  
Old June 10th, 2009, 05:06 PM posted to microsoft.public.outlook.contacts
Gordon[_13_]
external usenet poster
 
Posts: 3,406
Default Import formatted label list into Outlook Contacts

Juanbal wrote:
I am not making myself clear. One more try.
1.) I had a Contacts folder with a thousand contacts.
2.) I merged these contacts into a Word document containing the one thousand
contacts.
3.) Subsequent to this merge, we inadvertently deleted (for the sake of
argument) all one thousand contacts from the Contacts folder.
4.) Now, all we have is the merged document containing the contacts.
5.) We can cut and paste unto outlook contacts one by one; or is there an
easier way to do this that would not require such labor intensive effort?

I apologize for expressing myself this way. I truly do appreciate your
effort Russ. If we have to do it "by hand" so be it. I was looking for an
easier way of doing it.

Thank you again.


Save the document as a text file (*.txt)
Open in Excel. Then you may have to manipulate the data somewhat. Save
As a CSV file and import that directly to Outlook.

Good luck!

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:26 AM.


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