Envelope address

[Avionics Dave]

How do I save the customized address location (From Top and From Left) that I
typed in for a custom envelope size? I want to do this so that I can come
back to it at a later date. I will be adressing hundred of envelopes to
different customers over the next couple of months.

 

[John W. Vinson]

How do I save the customized address location (From Top and From Left) that I
typed in for a custom envelope size? I want to do this so that I can come
back to it at a later date. I will be adressing hundred of envelopes to
different customers over the next couple of months.

What I've done is create a Report with the textboxes in the desired location,
using File... Page Setup to set up a custom paper size for the envelope.
There's no need to programmatically mess with the From Top/From Left
properties.

 

[Avionics Dave]

Thanks, John. Did you do this in Word or Access? I am starting from Word,
with about 500 letters that I created from an Excel customer list using Mail
Merge. Each letter has the customer's address on it. I have never used
Access. If that is the best program to use, is there a downloadable user's
guide?

 

[John W. Vinson]

Thanks, John. Did you do this in Word or Access? I am starting from Word,
with about 500 letters that I created from an Excel customer list using Mail
Merge. Each letter has the customer's address on it. I have never used
Access. If that is the best program to use, is there a downloadable user's
guide?

Well... you did post your question in a newsgroup supporting Access, which is
why I assumed you were in fact using Access. The webpage can be confusing, and
may have misled you; the first alphabetical subject area on the Office
heirarchy is this one, for Microsoft Access. You need to scroll down the list
to find a newsgroup for Word.

That said, yes, Access is very well suited to maintaining lists of addresses
(and lists of all sorts). It is, however, a much more complex program than
Excel or Word and has a steep learning curve. If you want to investigate it
see some of the introductory material at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Avionics Dave]

Thanks for the explanation and your help. This is my first time using this
site and I was confused. After reading your message and looking at the page
more closely, I see how it is set up. It isn't that difficult, I just did it
in too much of a hurry yesterday. I will check out the introductory
material. Thanks again.