P
Pat the Rat
Can't you print address labels onto normal Avery 1" X
2,5/8" from an Excel database?
2,5/8" from an Excel database?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David McRitchie
Trying to print labels directly from Excel and from printer to another
would cause you a lot of trouble.
To print labels in MS Word using Mail Merge (MS Word) from Excel
see http://www.mvps.org/dmcritchie/excel/mailmerg.htm
remember to move the worksheet tab to the far left so that
it is the first worksheet.
would cause you a lot of trouble.
To print labels in MS Word using Mail Merge (MS Word) from Excel
see http://www.mvps.org/dmcritchie/excel/mailmerg.htm
remember to move the worksheet tab to the far left so that
it is the first worksheet.
P
P. J.
David--
I have been copying and pasting a spreadsheet into
a "throwaway" workbook to do this! Thanks for the
information!! Hey, will it print labels only from those
visible after I use the auto filter to bring up those for
which I need labels?
Thanks again!!
P.J.
I have been copying and pasting a spreadsheet into
a "throwaway" workbook to do this! Thanks for the
information!! Hey, will it print labels only from those
visible after I use the auto filter to bring up those for
which I need labels?
Thanks again!!
P.J.
D
David McRitchie
Hi P.J.,
Yes it will. Filtered lists are nice. Another thing that a
filtered list gets you is that Copy (ctrl+c) from a filtered
list will only copy the cells remaining after filtering so
the use of a filtered list to restrict input into Mail Merge is not
really an exception.
Yes it will. Filtered lists are nice. Another thing that a
filtered list gets you is that Copy (ctrl+c) from a filtered
list will only copy the cells remaining after filtering so
the use of a filtered list to restrict input into Mail Merge is not
really an exception.
K
k littlefield
you need to bring your excel file and do a mailmerge into
Word. Do go Tools
Word. Do go Tools