addressing from access or excel

[hiramsquared]

I have preprinted forms that I need to address. My members data is in Excel,
but I can convert it to Access if needed. I want to address the forms in the
proper spot, then fold and insert to window envelopes. I want to avoid
printing labels and then havign to stick them on the forms. How can I do
this, please and many thnaks in advance.

--pwf

 

[Wayne-I-M]

Hi

You would be better createing s report from your date instead of sending a
form printout.

Create a query from the data and then create a report from this

Say you have
1st name
2nd name
address1
address2
address3
address4
Zip/Post code

In your query

You can make your address look a little bit better by using J Smith instead
of John Smith

So 1st in the query create a calculated column called Capital like this to
get the 1st letter of the 1st name
Capital: Left([1stName],1)

Next (in the report) create a text box with something like this as the
control source

=([Capital] & " " & [2ndName]) & Chr(13)+Chr(10)+[Address1t] &
Chr(13)+Chr(10)+[Address2] & Chr(13)+Chr(10)+[Address3] &
Chr(13)+Chr(10)+[Address4] & Chr(13)+Chr(10)+[Zip/Post Code]


Of course change the field names to what you really use

Position this where it will be seen in the envelope window

 

[Wayne-I-M]

Sorry just re-read your post - use the address box to insert the address on
to your pre-printed forms - position them so they will be seen in the
envelope window

 

[Larry Daugherty]

How about using Mail Merge in Word? Word gives you greater
flexibility in locating your address info properly for your windowed
envelope.

HTH