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
  #11  
Old June 10th, 2009, 05:31 PM posted to microsoft.public.outlook.contacts
Juanbal
external usenet poster
 
Posts: 6
Default Import formatted label list into Outlook Contacts

Thanks Gordon. I will try and get back.
--
Juanbal


"Gordon" wrote:

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)

  #12  
Old June 10th, 2009, 09:25 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

I see now. It was never clear that you had destroyed the original Contacts
and were trying to recreate them from scratch using a "reverse mail merge."
Gordon's idea is what I'd try.
--
Russ Valentine
[MVP-Outlook]
"Juanbal" wrote in message
...
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?





 




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 04:31 PM.


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