| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Print envelopes for mass mailing from list of addresses in word do
I have Office 2003. I have been given a list of addresses in a word document.
The names and addresses are not in a table....format looks like this: Mr and Mrs John Jones 123 Somewhere Lane Little City, VA 12345 Jane Smith 456 Main Street Big Town, NC 67890 I have probably 150+ names. I need to print envelopes for each address and I need to put a return address on the envelope. My boss would like a logo included in the return address. She does not want to use labels. I need help. And since I'm not overly familiar with anything except printing one envelope for a single letter I need detailed directions!!! Can anyone help me? I have to have this completed by mid-day tomorrow, Thur. 7/24/08!! |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Print envelopes for mass mailing from list of addresses in word do
You're going to have to do some work to rearrange the data into a mail merge
source document. See http://www.gmayor.com/convert_labels...mail_merge.htm for instructions. After that's ready, you can run mail merges to envelopes just as easilly as to labels. -- 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. Blue Bunny wrote: I have Office 2003. I have been given a list of addresses in a word document. The names and addresses are not in a table....format looks like this: Mr and Mrs John Jones 123 Somewhere Lane Little City, VA 12345 Jane Smith 456 Main Street Big Town, NC 67890 I have probably 150+ names. I need to print envelopes for each address and I need to put a return address on the envelope. My boss would like a logo included in the return address. She does not want to use labels. I need help. And since I'm not overly familiar with anything except printing one envelope for a single letter I need detailed directions!!! Can anyone help me? I have to have this completed by mid-day tomorrow, Thur. 7/24/08!! |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Print envelopes for mass mailing from list of addresses in word do
If this is a one-time job, the simplest approach is to create a
single-column data source with the entire address in a single cell. If each address is a single paragraph, that's a very simple Convert Text to Table operation, separating at paragraphs. If each line is a paragraph but there is an empty paragraph between addresses, then that's almost as simple. It just requires replacing paragraph breaks (^p) with line breaks (^l) and then replacing two line breaks (^l^l) with a paragraph break, then converting the text to a table, separating at paragraphs. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Jay Freedman" wrote in message ... You're going to have to do some work to rearrange the data into a mail merge source document. See http://www.gmayor.com/convert_labels...mail_merge.htm for instructions. After that's ready, you can run mail merges to envelopes just as easilly as to labels. -- 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. Blue Bunny wrote: I have Office 2003. I have been given a list of addresses in a word document. The names and addresses are not in a table....format looks like this: Mr and Mrs John Jones 123 Somewhere Lane Little City, VA 12345 Jane Smith 456 Main Street Big Town, NC 67890 I have probably 150+ names. I need to print envelopes for each address and I need to put a return address on the envelope. My boss would like a logo included in the return address. She does not want to use labels. I need help. And since I'm not overly familiar with anything except printing one envelope for a single letter I need detailed directions!!! Can anyone help me? I have to have this completed by mid-day tomorrow, Thur. 7/24/08!! |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Print envelopes for mass mailing from list of addresses in wor
Jay & Suzanne - thanks for responding so quickly and with good solutions. But
you have made me realize I may be focusing on one task instead of the "big picture". The list of addresses I have now in a word doc is a list of people for a community fund raising project. In other words, we'll prob be contacting some of these people again with letters, tracking pledges, etc. So I'll be sending out envelopes & letters on an ongoing basis for a while. Should I just manually type these names into an address book? I've not used Outlook but I have it....... Or should I set up the names in Excel? ......Suggestions please!! "Suzanne S. Barnhill" wrote: If this is a one-time job, the simplest approach is to create a single-column data source with the entire address in a single cell. If each address is a single paragraph, that's a very simple Convert Text to Table operation, separating at paragraphs. If each line is a paragraph but there is an empty paragraph between addresses, then that's almost as simple. It just requires replacing paragraph breaks (^p) with line breaks (^l) and then replacing two line breaks (^l^l) with a paragraph break, then converting the text to a table, separating at paragraphs. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Jay Freedman" wrote in message ... You're going to have to do some work to rearrange the data into a mail merge source document. See http://www.gmayor.com/convert_labels...mail_merge.htm for instructions. After that's ready, you can run mail merges to envelopes just as easilly as to labels. -- 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. Blue Bunny wrote: I have Office 2003. I have been given a list of addresses in a word document. The names and addresses are not in a table....format looks like this: Mr and Mrs John Jones 123 Somewhere Lane Little City, VA 12345 Jane Smith 456 Main Street Big Town, NC 67890 I have probably 150+ names. I need to print envelopes for each address and I need to put a return address on the envelope. My boss would like a logo included in the return address. She does not want to use labels. I need help. And since I'm not overly familiar with anything except printing one envelope for a single letter I need detailed directions!!! Can anyone help me? I have to have this completed by mid-day tomorrow, Thur. 7/24/08!! |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Print envelopes for mass mailing from list of addresses in wor
Please read the article I cited befo
http://www.gmayor.com/convert_labels...mail_merge.htm The result of that process is a Word file containing the names and addresses in a format that can be used by the mail merge feature. Once you have that document (and you can later add to it, remove names, update addresses, and so forth), you can then print labels, envelopes, form letters, and several other kinds of documents from the same data. You could transfer the information to Excel -- simply by copying the table from Word and pasting it into a blank worksheet -- but there's no particular advantage in doing so. Whatever you do, don't waste your time manually typing everything over again. -- 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 Wed, 23 Jul 2008 18:07:00 -0700, Blue Bunny wrote: Jay & Suzanne - thanks for responding so quickly and with good solutions. But you have made me realize I may be focusing on one task instead of the "big picture". The list of addresses I have now in a word doc is a list of people for a community fund raising project. In other words, we'll prob be contacting some of these people again with letters, tracking pledges, etc. So I'll be sending out envelopes & letters on an ongoing basis for a while. Should I just manually type these names into an address book? I've not used Outlook but I have it....... Or should I set up the names in Excel? .....Suggestions please!! "Suzanne S. Barnhill" wrote: If this is a one-time job, the simplest approach is to create a single-column data source with the entire address in a single cell. If each address is a single paragraph, that's a very simple Convert Text to Table operation, separating at paragraphs. If each line is a paragraph but there is an empty paragraph between addresses, then that's almost as simple. It just requires replacing paragraph breaks (^p) with line breaks (^l) and then replacing two line breaks (^l^l) with a paragraph break, then converting the text to a table, separating at paragraphs. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Jay Freedman" wrote in message ... You're going to have to do some work to rearrange the data into a mail merge source document. See http://www.gmayor.com/convert_labels...mail_merge.htm for instructions. After that's ready, you can run mail merges to envelopes just as easilly as to labels. -- 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. Blue Bunny wrote: I have Office 2003. I have been given a list of addresses in a word document. The names and addresses are not in a table....format looks like this: Mr and Mrs John Jones 123 Somewhere Lane Little City, VA 12345 Jane Smith 456 Main Street Big Town, NC 67890 I have probably 150+ names. I need to print envelopes for each address and I need to put a return address on the envelope. My boss would like a logo included in the return address. She does not want to use labels. I need help. And since I'm not overly familiar with anything except printing one envelope for a single letter I need detailed directions!!! Can anyone help me? I have to have this completed by mid-day tomorrow, Thur. 7/24/08!! |
|
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Print envelopes for mass mailing from list of addresses in wor
If you stop the cited process at the point where the file is a comma
delimited text file you can import the file into Outlook or simply open it in Excel, but for the purpose of mail merge, as Jay says, it is easier to use the Word document as a data source. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jay Freedman wrote: Please read the article I cited befo http://www.gmayor.com/convert_labels...mail_merge.htm The result of that process is a Word file containing the names and addresses in a format that can be used by the mail merge feature. Once you have that document (and you can later add to it, remove names, update addresses, and so forth), you can then print labels, envelopes, form letters, and several other kinds of documents from the same data. You could transfer the information to Excel -- simply by copying the table from Word and pasting it into a blank worksheet -- but there's no particular advantage in doing so. Whatever you do, don't waste your time manually typing everything over again. Jay & Suzanne - thanks for responding so quickly and with good solutions. But you have made me realize I may be focusing on one task instead of the "big picture". The list of addresses I have now in a word doc is a list of people for a community fund raising project. In other words, we'll prob be contacting some of these people again with letters, tracking pledges, etc. So I'll be sending out envelopes & letters on an ongoing basis for a while. Should I just manually type these names into an address book? I've not used Outlook but I have it....... Or should I set up the names in Excel? .....Suggestions please!! "Suzanne S. Barnhill" wrote: If this is a one-time job, the simplest approach is to create a single-column data source with the entire address in a single cell. If each address is a single paragraph, that's a very simple Convert Text to Table operation, separating at paragraphs. If each line is a paragraph but there is an empty paragraph between addresses, then that's almost as simple. It just requires replacing paragraph breaks (^p) with line breaks (^l) and then replacing two line breaks (^l^l) with a paragraph break, then converting the text to a table, separating at paragraphs. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Jay Freedman" wrote in message ... You're going to have to do some work to rearrange the data into a mail merge source document. See http://www.gmayor.com/convert_labels...mail_merge.htm for instructions. After that's ready, you can run mail merges to envelopes just as easilly as to labels. -- 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. Blue Bunny wrote: I have Office 2003. I have been given a list of addresses in a word document. The names and addresses are not in a table....format looks like this: Mr and Mrs John Jones 123 Somewhere Lane Little City, VA 12345 Jane Smith 456 Main Street Big Town, NC 67890 I have probably 150+ names. I need to print envelopes for each address and I need to put a return address on the envelope. My boss would like a logo included in the return address. She does not want to use labels. I need help. And since I'm not overly familiar with anything except printing one envelope for a single letter I need detailed directions!!! Can anyone help me? I have to have this completed by mid-day tomorrow, Thur. 7/24/08!! |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you print mass mailing lables? | Microsoft Word Help | |||
| How do I add P. O. Box #'s to mass mailing list (in sequence)? | New Users | |||
| How do I save mailing addresses to print on envelopes? | Mailmerge | |||
| how do you store addresses for mailing labels or envelopes? | New Users | |||
| How to make list of names & addresses to list of mailing labels? | Microsoft Word Help | |||
Linear Mode
