![]() |
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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
#4
|
|||
|
|||
![]()
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 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 |
#5
|
|||
|
|||
![]()
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 |
#6
|
|||
|
|||
![]()
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 |
#7
|
|||
|
|||
![]()
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 . |
#8
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
|
Thread Tools | |
Display Modes | |
|
|