Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print names and addresses on a preprinted postcard?
I have a file that originated in MS Excel with names and addresses. I want
to send each of them a preprinted 4.25" x 5.5" postcard, and have the printer print the address on each postcard. Using the mail merge function of MS Word doesn't seem to be working and is just frustrating me. Any ideas on steps to take to get this working right? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print names and addresses on a preprinted postcard?
If they are individual postcards this is a straightforward letter merge. If
they are microperforated cards 3 or 4 to a sheet then it would be a label merge. For either - http://www.gmayor.com/mail_merge_lab...th_word_xp.htm should help. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: I have a file that originated in MS Excel with names and addresses. I want to send each of them a preprinted 4.25" x 5.5" postcard, and have the printer print the address on each postcard. Using the mail merge function of MS Word doesn't seem to be working and is just frustrating me. Any ideas on steps to take to get this working right? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print names and addresses on a preprinted postcard?
Thank you Graham. That was a wonderful write-up that you had, and it cleared
up a lot of my mail merge questions. I wasn't able to make this work with letters (due to page size), so chose the label route, and found a postcard in that menu that matches the size that I have. Everything is working except that I can't get the name and address to print in the lower right quarter of the postcard. MS Word wants to print it near the top or middle right, and nothing that I do seems to correct that. Any suggestions? "Graham Mayor" wrote: If they are individual postcards this is a straightforward letter merge. If they are microperforated cards 3 or 4 to a sheet then it would be a label merge. For either - http://www.gmayor.com/mail_merge_lab...th_word_xp.htm should help. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: I have a file that originated in MS Excel with names and addresses. I want to send each of them a preprinted 4.25" x 5.5" postcard, and have the printer print the address on each postcard. Using the mail merge function of MS Word doesn't seem to be working and is just frustrating me. Any ideas on steps to take to get this working right? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print names and addresses on a preprinted postcard?
Text in a table is subject to the same formatting commands as any other
text. By means of a combination of cell alignment and paragraph formatting you can place the text anywhere in the cell. Start with the cell alignment to 'Top' use spacing before the first paragraph around 2" and if you want it on the right set a tab stop. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: Thank you Graham. That was a wonderful write-up that you had, and it cleared up a lot of my mail merge questions. I wasn't able to make this work with letters (due to page size), so chose the label route, and found a postcard in that menu that matches the size that I have. Everything is working except that I can't get the name and address to print in the lower right quarter of the postcard. MS Word wants to print it near the top or middle right, and nothing that I do seems to correct that. Any suggestions? "Graham Mayor" wrote: If they are individual postcards this is a straightforward letter merge. If they are microperforated cards 3 or 4 to a sheet then it would be a label merge. For either - http://www.gmayor.com/mail_merge_lab...th_word_xp.htm should help. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: I have a file that originated in MS Excel with names and addresses. I want to send each of them a preprinted 4.25" x 5.5" postcard, and have the printer print the address on each postcard. Using the mail merge function of MS Word doesn't seem to be working and is just frustrating me. Any ideas on steps to take to get this working right? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print names and addresses on a preprinted postcard?
Graham,
Thank you. My formatting seems to be okay left-to-right. It is the distance from the top that is causing me problems. I had thought that I could fix it with a Format-Paragraph command or something in page setup, but it doesn't seem to be working. On my screen, I can see four postcards that are correct in every other way. Thanks again for your help. Sorry to be a bother. "Graham Mayor" wrote: Text in a table is subject to the same formatting commands as any other text. By means of a combination of cell alignment and paragraph formatting you can place the text anywhere in the cell. Start with the cell alignment to 'Top' use spacing before the first paragraph around 2" and if you want it on the right set a tab stop. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: Thank you Graham. That was a wonderful write-up that you had, and it cleared up a lot of my mail merge questions. I wasn't able to make this work with letters (due to page size), so chose the label route, and found a postcard in that menu that matches the size that I have. Everything is working except that I can't get the name and address to print in the lower right quarter of the postcard. MS Word wants to print it near the top or middle right, and nothing that I do seems to correct that. Any suggestions? "Graham Mayor" wrote: If they are individual postcards this is a straightforward letter merge. If they are microperforated cards 3 or 4 to a sheet then it would be a label merge. For either - http://www.gmayor.com/mail_merge_lab...th_word_xp.htm should help. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: I have a file that originated in MS Excel with names and addresses. I want to send each of them a preprinted 4.25" x 5.5" postcard, and have the printer print the address on each postcard. Using the mail merge function of MS Word doesn't seem to be working and is just frustrating me. Any ideas on steps to take to get this working right? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print names and addresses on a preprinted postcard?
Select the first line of the address. Right click paragraph in the space
before box type (say) 2". This will drop that line by two inches. The rest will surely follow. Propagate the labels to add the changes to the other labels. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: Graham, Thank you. My formatting seems to be okay left-to-right. It is the distance from the top that is causing me problems. I had thought that I could fix it with a Format-Paragraph command or something in page setup, but it doesn't seem to be working. On my screen, I can see four postcards that are correct in every other way. Thanks again for your help. Sorry to be a bother. "Graham Mayor" wrote: Text in a table is subject to the same formatting commands as any other text. By means of a combination of cell alignment and paragraph formatting you can place the text anywhere in the cell. Start with the cell alignment to 'Top' use spacing before the first paragraph around 2" and if you want it on the right set a tab stop. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: Thank you Graham. That was a wonderful write-up that you had, and it cleared up a lot of my mail merge questions. I wasn't able to make this work with letters (due to page size), so chose the label route, and found a postcard in that menu that matches the size that I have. Everything is working except that I can't get the name and address to print in the lower right quarter of the postcard. MS Word wants to print it near the top or middle right, and nothing that I do seems to correct that. Any suggestions? "Graham Mayor" wrote: If they are individual postcards this is a straightforward letter merge. If they are microperforated cards 3 or 4 to a sheet then it would be a label merge. For either - http://www.gmayor.com/mail_merge_lab...th_word_xp.htm should help. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: I have a file that originated in MS Excel with names and addresses. I want to send each of them a preprinted 4.25" x 5.5" postcard, and have the printer print the address on each postcard. Using the mail merge function of MS Word doesn't seem to be working and is just frustrating me. Any ideas on steps to take to get this working right? |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I print names and addresses on a preprinted postcard?
Graham,
I wasn't able to get that to work. However, I think that I found a work-around by having the postcards pretend to be envelopes. Thanks again for all of your assistance. Sincerely, Alan Noblitt "Graham Mayor" wrote: Select the first line of the address. Right click paragraph in the space before box type (say) 2". This will drop that line by two inches. The rest will surely follow. Propagate the labels to add the changes to the other labels. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: Graham, Thank you. My formatting seems to be okay left-to-right. It is the distance from the top that is causing me problems. I had thought that I could fix it with a Format-Paragraph command or something in page setup, but it doesn't seem to be working. On my screen, I can see four postcards that are correct in every other way. Thanks again for your help. Sorry to be a bother. "Graham Mayor" wrote: Text in a table is subject to the same formatting commands as any other text. By means of a combination of cell alignment and paragraph formatting you can place the text anywhere in the cell. Start with the cell alignment to 'Top' use spacing before the first paragraph around 2" and if you want it on the right set a tab stop. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: Thank you Graham. That was a wonderful write-up that you had, and it cleared up a lot of my mail merge questions. I wasn't able to make this work with letters (due to page size), so chose the label route, and found a postcard in that menu that matches the size that I have. Everything is working except that I can't get the name and address to print in the lower right quarter of the postcard. MS Word wants to print it near the top or middle right, and nothing that I do seems to correct that. Any suggestions? "Graham Mayor" wrote: If they are individual postcards this is a straightforward letter merge. If they are microperforated cards 3 or 4 to a sheet then it would be a label merge. For either - http://www.gmayor.com/mail_merge_lab...th_word_xp.htm should help. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org A Noblitt wrote: I have a file that originated in MS Excel with names and addresses. I want to send each of them a preprinted 4.25" x 5.5" postcard, and have the printer print the address on each postcard. Using the mail merge function of MS Word doesn't seem to be working and is just frustrating me. Any ideas on steps to take to get this working right? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create labels from names and addresses in Excel? | Microsoft Word Help | |||
How do I add multiple names and addresses to a transmittal? | Mailmerge | |||
How do I center my names and addresses in labels? | Mailmerge | |||
how do I get my Word list of names and addresses into avery 5660 . | Microsoft Word Help |