OK, this one should be easy (I am posting today all of the annoying
problems that have accumulated over the past few months). I want to
make envelopes using access 2000 rather than having to export my query
to excel and then merge into word.
I want to use the following fields:
<firstname> <lastnmae>
<institution>
<department>
<streetorbox>
<city> <state> <zip>
<country>
all laid out as above. However, I want to suppress blank lines (some
of the addresses do not have the institution line or the department
line used). These should be formatted in the report so that they are
on a standard #10 envelope with a static return address (just text,
not merged fields). It should be able to create a report from a query
and thus have 1 or 100 or 1000 or even more envelopes in the report
(as many envelopes as lines in the query) that may then be printed off
onto regular envelopes using my printer.
I feel a bit like an idiot here as I have tried this numerous times
and each time one or more problems derails me. |
Request for Question Clarification by
alienintelligence-ga
on
29 Dec 2003 21:28 PST
Hi susank,
I thought before I start on a solution
for you, I might ask... do you already
have a preferred way in mind or will
any method be ok as long as it works?
thanks,
-AI
|
Request for Question Clarification by
muhammad-ga
on
30 Dec 2003 04:46 PST
Hello susank,
I feel the needful can be accomplished by writing VB code (which MS
Access supports) which prints the labels in the format specified by
you.
Do let me know if you would qualify that as an answer. If yes, then I
will also like to know the Software versions and Printer model (and
its basic features) to write a workable code for your requirements.
Cheers!
|
Request for Question Clarification by
alienintelligence-ga
on
30 Dec 2003 21:34 PST
Hi again susank,
I created your Access file. I put in a few
dummy records and have printed them out. I
used a HP LaserJet 4+ and the envelope feeder.
All the envelopes printed fine and I even
got the spacing correct on the first guess.
The blank fields were suppressed.
It consists of a table, with 9 fields, a form
for convenient entry, and the report which
currently generates an output of all records,
as #10's. There is no formatting on the form,
just generic. Query generation will be up to
you.
Is this all you required for your answer? If
so, I will upload the file to my website and
post as the final answer.
thanks,
-AI
|
Clarification of Question by
susank-ga
on
31 Dec 2003 05:48 PST
My apologies for the delay - I was out yesterday. I believe that your
response AI would meet my needs. Here is where I had problems:
1. I couldn't get the report to orient in a way that printed
appropriately on #10 envelopes as fed into my printer. By that, I mean
that my reports are all oriented horizontally, but I could not get the
report to orient sideways so that the printer would envelopes properly
on my HP Laserjet 4050 (or any of the other three printers around
here). I know that there is something amiss here and the answer should
be obvious - but I couldn't figure out what.
2. I couldn't get the appropriate page breaks to be inserted so that I
could print multiple envelopes at once (of course each with a
different address in the query).
If you have solved these two problems, I can certainly alter what you
have sent to fit my database and insert the return address. Thanks!
|
Request for Question Clarification by
alienintelligence-ga
on
31 Dec 2003 11:54 PST
Hi susank,
Before I post it as a final answer,
I wanted to clarify a few last things.
You said,
"2. I couldn't get the appropriate page
breaks to be inserted so that I could print
multiple envelopes at once "
Just wanted to verify that by ?multiple
envelopes at once?, you mean, multiple
envelopes, sequentially fed (not manual
fed), and not 2 or 3 envelopes across,
at the same time thru the printer.
Mine is set up to receive a stack of
envelopes and automatically feed, one
by one, with a unique record on each.
FYI, for my test, I put in not only
dummy records but a fake return
address. I wasn?t sure if you were
using pre-printed envelopes or
wanted to generate the return
address at the same time.
One more thing, if your printer is
misconfigured, your results may not
be exactly the same as mine. If this
occurs, please ask for clarifications
before rating the answer so we can
get your setup dialed in and working
properly.
thanks,
-AI
|
Clarification of Question by
susank-ga
on
07 Jan 2004 16:08 PST
My apologies for the delay. I had a family emergency.
Yes, that is exactly what I mean - printing 1 or 100 or 1000 envelopes
sequentially, one at a time, each with a different address
representing a different record in the appropriate query.
I thank you so much for asking for the clarification. I'll try out
your answer and then will clarify if I need more help regarding the
printer configuration.
As a note, I am traveling quite a bit over the next few weeks. Please
do not take it as a problem if I do not respond properly. I thank you
for the time you take!
|
