help with retreive print

  • Thread starter Thread starter chessieman
  • Start date Start date
C

chessieman

i need to search excel database and automatically print to a labe
printer. also need to be building a manifest at the same time. mayb
there is an off the shelf macros? any help would be greatl
appreciated. thank
 
Don't know if this will help you or not, but

If you have all of your data set up on one worksheet, you can use a filter
to filter your data. The copy (Ctrl+C) and Mail Merge will only see those
rows that are left after filtering.

Excel is not good at printing labels, if you do you must NOT set up to
fit to page, you can't change printers, fonts or stuff once you've setup.
It is VERY difficult to control. You are expected to use MS Word to
print and to use Excel as the database instead of using Excel to print.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

If you need help with filtering, see Debra Dalgleish's
http://www.contextures.com/tiptech.html
and Data Pig Technologies, which has a lot of helpful videos that you can run.
Tips on Filtering with "AutoFilter"
http://www.datapigtechnologies.com/flashfiles/autofilter.html

Perhaps the manifest would be your filtered spreadsheet itself,
depending on who gets the list.

Use of a web based reader that puts (repeats) newsgroup postings as
web pages is the equivalent of spam among web pages. Your question
was answered in a newsgroup. Google will keep web pages and
newsgroups separate as long as questions come in directly from a
newsgroup. Filtering out the noise from so called forums when searching
web pages is becoming more of a nuisance than filtering out spam
from emails.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top