Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / April 2008

Tip: Looking for answers? Try searching our database.

Envelope address

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Avionics Dave - 28 Apr 2008 20:20 GMT
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.
Signature

Dave

John W. Vinson - 29 Apr 2008 00:21 GMT
>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.

Signature

            John W. Vinson [MVP]

Avionics Dave - 29 Apr 2008 16:02 GMT
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?    
Signature

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
[quoted text clipped - 5 lines]
> There's no need to programmatically mess with the From Top/From Left
> properties.
John W. Vinson - 29 Apr 2008 17:37 GMT
>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
Signature


            John W. Vinson [MVP]

Avionics Dave - 29 Apr 2008 19:16 GMT
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.
Signature

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
[quoted text clipped - 24 lines]
> MVP Allen Browne's tutorials:
> http://allenbrowne.com/links.html#Tutorials
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.