Exporting to word for envelope

[Guest]

My read-only users need to have the capability to print envelopes from the
contact form I set up for them. I would like to set up a command button
"Envelopes" and have the data export to word so they can then print an
envelope. I don't know how to do this or if this is the best way of doing
this.

It was suggested that I have them use the mail merge in word pulling the
info from access, but none of my "high maintenance" users know how to use
mail merge, nor will they learn. So I need a very pain free (for them) way
of doing this.

Any suggestions would be greatly appreciated.

 

[fredg]

My read-only users need to have the capability to print envelopes from the
contact form I set up for them. I would like to set up a command button
"Envelopes" and have the data export to word so they can then print an
envelope. I don't know how to do this or if this is the best way of doing
this.

It was suggested that I have them use the mail merge in word pulling the
info from access, but none of my "high maintenance" users know how to use
mail merge, nor will they learn. So I need a very pain free (for them) way
of doing this.

Any suggestions would be greatly appreciated.

What do you need Word for?

Printing on an envelope in Access is just like printing any other
report.

First you must determine if your report is going to print in Portrait
or Landscape mode.
If the envelope feeds into the printer narrow side first, it will be
in Landscape.
If flap side first, portrait.

The below instructions are for Landscape.

Make a new report.
Place the Address labels at the left margin.
Size the width of the report just a bit wider than the labels.

Click File + PageSetUp + Page
Set the Paper Size property to the size of the envelope.
Since the envelope feeds in narrow side first,
set the Page Orientation to Landscape.
Then click on the Margins tab.
Set the Left and Top margins to print the address at the proper place
on the envelope.
For example, to print on a #10 business envelope I set the Top margin
to 2.75" and the Left margin to 3" in Landscape.

Print a sample.
Readjust margin settings as needed

For Portrait mode, follow the above instructions, but, of course,
change the Page SetUp mode to Portrait, and adjust the margin settings
accordingly.

 

[Mikal via AccessMonster.com]

Lori,

Fredg is right.

However, if you copy the database from one machine to another (as you might
do if you promulgate a new edition) Access will reset your envelopes to
letter size paper (or what ever you have set as your Windows Default paper
size). This can be very aggravating. If you create an envelope in Word,
however and merge the Access data into it, it will remain an envelope no
matter what you do with the database. That being said, Access and Word work
miserably together. A guy named Albert Kallal has some code that solves the
problem. He even gives it away free. Here is a link to his website:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html


Look for Super Easy Word Merge.

Mike