Print addresses from an exel worksheet to envelopes
I am trying to print addresses from an excel file on envelopes. I know how to
do the labels, but not sure how to print onto envelopes. |
Most users with address in Excel use Word for mail merge. It is easy to tell
Word to get its data from an Excel worksheet. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sherry Lee" wrote in message ... I am trying to print addresses from an excel file on envelopes. I know how to do the labels, but not sure how to print onto envelopes. |
I do not think I phrased that question right. I know how to import the file
from excel into the word document, but wondered what the procedures are to print the address (from excel) onto envelopes. I am having trouble with it. Plus, it only shows one record at a time. Is there a way to print continuous instead of just one record at a time. Thanks for your help. "Bernard Liengme" wrote: Most users with address in Excel use Word for mail merge. It is easy to tell Word to get its data from an Excel worksheet. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sherry Lee" wrote in message ... I am trying to print addresses from an excel file on envelopes. I know how to do the labels, but not sure how to print onto envelopes. |
Also, I was wondering if there is a way to raise the mailing address. I am
using the "envelope address" format, but it is too low for the envelope. I used the custom setting for indicating the size of the envelope. Any suggestions? "Bernard Liengme" wrote: Most users with address in Excel use Word for mail merge. It is easy to tell Word to get its data from an Excel worksheet. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sherry Lee" wrote in message ... I am trying to print addresses from an excel file on envelopes. I know how to do the labels, but not sure how to print onto envelopes. |
If I need to know something about mailmerge, I start he
http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. After that, I go to google and search the MSWord newsgroups--if I have question on the MSWord side. If that fails, I post to one of the MSWord newsgroups. (If I had trouble with the excel side, I'd stay here.) Sherry Lee wrote: Also, I was wondering if there is a way to raise the mailing address. I am using the "envelope address" format, but it is too low for the envelope. I used the custom setting for indicating the size of the envelope. Any suggestions? "Bernard Liengme" wrote: Most users with address in Excel use Word for mail merge. It is easy to tell Word to get its data from an Excel worksheet. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sherry Lee" wrote in message ... I am trying to print addresses from an excel file on envelopes. I know how to do the labels, but not sure how to print onto envelopes. -- Dave Peterson |
All times are GMT +1. The time now is 01:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com