Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sherry Lee
 
Posts: n/a
Default 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.
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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.



  #3   Report Post  
Sherry Lee
 
Posts: n/a
Default

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.




  #4   Report Post  
Sherry Lee
 
Posts: n/a
Default

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.




  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I print out the formula in my worksheet? miquette Excel Discussion (Misc queries) 3 August 31st 05 01:37 AM
can i insert a print command in a worksheet? darin van houten Excel Discussion (Misc queries) 0 August 27th 05 10:19 PM
Can I copy a worksheet with its page setup and print formats? MSSAC_QA Excel Discussion (Misc queries) 2 July 14th 05 02:24 PM
Cannot print gridlines in worksheet even tho they show on screen papadip Excel Discussion (Misc queries) 3 June 6th 05 03:42 PM
print report with data from specific worksheet JG_HILL Excel Discussion (Misc queries) 1 May 14th 05 07:12 PM


All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"