Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
strawberryangel83 strawberryangel83 is offline
external usenet poster
 
Posts: 13
Default turning tables into labels, possible?

someone sent me a mailing list as a table that has over 100 names on there.
can i just convert the table into a mailing label format and print, so i wont
have to start a new contact list in access and retype all that info again?
the table has columns for: first name, last name, address, city, state, zip.
can i even do a mail merge? i want simple. i dont care how it's done. i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch
  #2   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default turning tables into labels, possible?

See http://www.word.mvps.org/FAQs/MailMe...ToDatafile.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"strawberryangel83" wrote in
message ...
someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print, so i
wont
have to start a new contact list in access and retype all that info again?
the table has columns for: first name, last name, address, city, state,
zip.
can i even do a mail merge? i want simple. i dont care how it's done. i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch


  #3   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default turning tables into labels, possible?

See €śConvert Labels into Mail Merge Data File€ť on fellow MVP Graham Mayors
website at:
http://www.gmayor.com/convert_labels...mail_merge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"strawberryangel83" wrote in
message ...
someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print, so i
wont
have to start a new contact list in access and retype all that info again?
the table has columns for: first name, last name, address, city, state,
zip.
can i even do a mail merge? i want simple. i dont care how it's done. i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch


  #4   Report Post  
Posted to microsoft.public.word.tables
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default turning tables into labels, possible?

And perhaps more useful -- since your addresses are already in the
table format that can serve as a mail merge data source -- is another
of Graham's articles,
http://www.gmayor.com/merge_labels_with_word_2007.htm

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.


On Fri, 5 Mar 2010 11:04:48 +1000, "Doug Robbins - Word MVP"
wrote:

See “Convert Labels into Mail Merge Data File” on fellow MVP Graham Mayor’s
website at:
http://www.gmayor.com/convert_labels...mail_merge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"strawberryangel83" wrote in
message ...
someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print, so i
wont
have to start a new contact list in access and retype all that info again?
the table has columns for: first name, last name, address, city, state,
zip.
can i even do a mail merge? i want simple. i dont care how it's done. i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch

  #5   Report Post  
Posted to microsoft.public.word.tables
strawberryangel83 strawberryangel83 is offline
external usenet poster
 
Posts: 13
Default turning tables into labels, possible?

The thing is, first name and last name are in two separate columns. when i
combine them, the first name is on top, and the last name is on bottom,
separated by a paragraph mark. How do i merge the cells so the first and
last names are side by side?

"Doug Robbins - Word MVP" wrote:

See €śConvert Labels into Mail Merge Data File€ť on fellow MVP Graham Mayors
website at:
http://www.gmayor.com/convert_labels...mail_merge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"strawberryangel83" wrote in
message ...
someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print, so i
wont
have to start a new contact list in access and retype all that info again?
the table has columns for: first name, last name, address, city, state,
zip.
can i even do a mail merge? i want simple. i dont care how it's done. i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch




  #6   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default turning tables into labels, possible?

Well, you really don't want to merge them for a data source. Leaving them in
separate fields allows you to sort by last name.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"strawberryangel83" wrote in
message ...
The thing is, first name and last name are in two separate columns. when
i
combine them, the first name is on top, and the last name is on bottom,
separated by a paragraph mark. How do i merge the cells so the first and
last names are side by side?

"Doug Robbins - Word MVP" wrote:

See €śConvert Labels into Mail Merge Data File€ť on fellow MVP Graham Mayors
website at:
http://www.gmayor.com/convert_labels...mail_merge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"strawberryangel83" wrote
in
message ...
someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print, so
i
wont
have to start a new contact list in access and retype all that info
again?
the table has columns for: first name, last name, address, city, state,
zip.
can i even do a mail merge? i want simple. i dont care how it's done.
i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch




  #7   Report Post  
Posted to microsoft.public.word.tables
strawberryangel83 strawberryangel83 is offline
external usenet poster
 
Posts: 13
Default turning tables into labels, possible?

That's what the instructions say to do that Jay posted. His post seems like
what I want to do.

The addresses are in a table with each column having: last name, first name,
address, city, state, and zip. How do i make these into labels without
having to go and retype all these? I don't care if I have to do mail merge
and just labels.

What do you feel is the best route? Thank you so much for this.

"Suzanne S. Barnhill" wrote:

Well, you really don't want to merge them for a data source. Leaving them in
separate fields allows you to sort by last name.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"strawberryangel83" wrote in
message ...
The thing is, first name and last name are in two separate columns. when
i
combine them, the first name is on top, and the last name is on bottom,
separated by a paragraph mark. How do i merge the cells so the first and
last names are side by side?

"Doug Robbins - Word MVP" wrote:

See €śConvert Labels into Mail Merge Data File€ť on fellow MVP Graham Mayors
website at:
http://www.gmayor.com/convert_labels...mail_merge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"strawberryangel83" wrote
in
message ...
someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print, so
i
wont
have to start a new contact list in access and retype all that info
again?
the table has columns for: first name, last name, address, city, state,
zip.
can i even do a mail merge? i want simple. i dont care how it's done.
i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch



.

  #8   Report Post  
Posted to microsoft.public.word.tables
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default turning tables into labels, possible?

Use the method described at
http://www.gmayor.com/merge_labels_with_word_2007.htm to create a label
merge, with your table as the attached data source. Insert the fields in the
first cell in the layout that you require and follow the instructions to
propagate them to the other cells. Merge to a new document or the printer.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"strawberryangel83" wrote in
message ...
That's what the instructions say to do that Jay posted. His post seems
like
what I want to do.

The addresses are in a table with each column having: last name, first
name,
address, city, state, and zip. How do i make these into labels without
having to go and retype all these? I don't care if I have to do mail
merge
and just labels.

What do you feel is the best route? Thank you so much for this.

"Suzanne S. Barnhill" wrote:

Well, you really don't want to merge them for a data source. Leaving them
in
separate fields allows you to sort by last name.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"strawberryangel83" wrote
in
message ...
The thing is, first name and last name are in two separate columns.
when
i
combine them, the first name is on top, and the last name is on bottom,
separated by a paragraph mark. How do i merge the cells so the first
and
last names are side by side?

"Doug Robbins - Word MVP" wrote:

See "Convert Labels into Mail Merge Data File" on fellow MVP Graham
Mayor's
website at:
http://www.gmayor.com/convert_labels...mail_merge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"strawberryangel83"
wrote
in
message ...
someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print,
so
i
wont
have to start a new contact list in access and retype all that info
again?
the table has columns for: first name, last name, address, city,
state,
zip.
can i even do a mail merge? i want simple. i dont care how it's
done.
i
want a simple mail out without having to retype all of this. it's
in
microsoft word 2007. thanks a bunch



.



  #9   Report Post  
Posted to microsoft.public.word.tables
strawberryangel83 strawberryangel83 is offline
external usenet poster
 
Posts: 13
Default turning tables into labels, possible?

OK, i did that. now a box comes up saying something about header delimiters.
i dont know what to do with that. this is what happened when i did what Jay
posted.

"Graham Mayor" wrote:

Use the method described at
http://www.gmayor.com/merge_labels_with_word_2007.htm to create a label
merge, with your table as the attached data source. Insert the fields in the
first cell in the layout that you require and follow the instructions to
propagate them to the other cells. Merge to a new document or the printer.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"strawberryangel83" wrote in
message ...
That's what the instructions say to do that Jay posted. His post seems
like
what I want to do.

The addresses are in a table with each column having: last name, first
name,
address, city, state, and zip. How do i make these into labels without
having to go and retype all these? I don't care if I have to do mail
merge
and just labels.

What do you feel is the best route? Thank you so much for this.

"Suzanne S. Barnhill" wrote:

Well, you really don't want to merge them for a data source. Leaving them
in
separate fields allows you to sort by last name.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"strawberryangel83" wrote
in
message ...
The thing is, first name and last name are in two separate columns.
when
i
combine them, the first name is on top, and the last name is on bottom,
separated by a paragraph mark. How do i merge the cells so the first
and
last names are side by side?

"Doug Robbins - Word MVP" wrote:

See "Convert Labels into Mail Merge Data File" on fellow MVP Graham
Mayor's
website at:
http://www.gmayor.com/convert_labels...mail_merge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"strawberryangel83"
wrote
in
message ...
someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print,
so
i
wont
have to start a new contact list in access and retype all that info
again?
the table has columns for: first name, last name, address, city,
state,
zip.
can i even do a mail merge? i want simple. i dont care how it's
done.
i
want a simple mail out without having to retype all of this. it's
in
microsoft word 2007. thanks a bunch



.



.

  #10   Report Post  
Posted to microsoft.public.word.tables
strawberryangel83 strawberryangel83 is offline
external usenet poster
 
Posts: 13
Default turning tables into labels, possible?

hey!!!! i just figured it out. i had to convert the table to text and
separate them with tab marks. save as, then just go and do a regular merge
for labels using the save as document. was that what you all were trying to
tell me to do?

"strawberryangel83" wrote:

someone sent me a mailing list as a table that has over 100 names on there.
can i just convert the table into a mailing label format and print, so i wont
have to start a new contact list in access and retype all that info again?
the table has columns for: first name, last name, address, city, state, zip.
can i even do a mail merge? i want simple. i dont care how it's done. i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch



  #11   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default turning tables into labels, possible?

No. It's possible you need to add a heading row to your table so that Word
has something to call the merge fields.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"strawberryangel83" wrote in
message ...
hey!!!! i just figured it out. i had to convert the table to text and
separate them with tab marks. save as, then just go and do a regular
merge
for labels using the save as document. was that what you all were trying
to
tell me to do?

"strawberryangel83" wrote:

someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print, so i
wont
have to start a new contact list in access and retype all that info
again?
the table has columns for: first name, last name, address, city, state,
zip.
can i even do a mail merge? i want simple. i dont care how it's done.
i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch



  #12   Report Post  
Posted to microsoft.public.word.tables
strawberryangel83 strawberryangel83 is offline
external usenet poster
 
Posts: 13
Default turning tables into labels, possible?

The labels are done and everything. What i described below is what I needed
to do. There was a header row. However, there needed to be header row
delimiters to separate the data. So I chose for tabs to be the separaters.

"Suzanne S. Barnhill" wrote:

No. It's possible you need to add a heading row to your table so that Word
has something to call the merge fields.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"strawberryangel83" wrote in
message ...
hey!!!! i just figured it out. i had to convert the table to text and
separate them with tab marks. save as, then just go and do a regular
merge
for labels using the save as document. was that what you all were trying
to
tell me to do?

"strawberryangel83" wrote:

someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print, so i
wont
have to start a new contact list in access and retype all that info
again?
the table has columns for: first name, last name, address, city, state,
zip.
can i even do a mail merge? i want simple. i dont care how it's done.
i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch



.

  #13   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default turning tables into labels, possible?

But there was no need to convert the table to text. Word is quite happy with
a table as a data source; I use them all the time.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"strawberryangel83" wrote in
message ...
The labels are done and everything. What i described below is what I
needed
to do. There was a header row. However, there needed to be header row
delimiters to separate the data. So I chose for tabs to be the
separaters.

"Suzanne S. Barnhill" wrote:

No. It's possible you need to add a heading row to your table so that
Word
has something to call the merge fields.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"strawberryangel83" wrote
in
message ...
hey!!!! i just figured it out. i had to convert the table to text and
separate them with tab marks. save as, then just go and do a regular
merge
for labels using the save as document. was that what you all were
trying
to
tell me to do?

"strawberryangel83" wrote:

someone sent me a mailing list as a table that has over 100 names on
there.
can i just convert the table into a mailing label format and print, so
i
wont
have to start a new contact list in access and retype all that info
again?
the table has columns for: first name, last name, address, city,
state,
zip.
can i even do a mail merge? i want simple. i dont care how it's
done.
i
want a simple mail out without having to retype all of this. it's in
microsoft word 2007. thanks a bunch


.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tables turning black tafkamtes Microsoft Word Help 2 February 10th 10 09:42 PM
Printing Labels From Tables jliz2803 Mailmerge 1 April 9th 09 07:30 AM
TABLES & LABELS Lab Man Chris Tables 2 August 23rd 07 11:44 PM
Creating labels in tables Brettjs Tables 1 July 25th 06 02:13 PM
Mail merge using labels and tables DanaHuffman Mailmerge 2 December 28th 04 08:42 AM


All times are GMT +1. The time now is 12:06 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"