Addresses

F

Fay

Can you point me in the right direction? I want to combine the address fields
into one textbox. Then I want to click a button to create an envelop. Thank
you.
 
D

David C. Holley

I would HIGHLY recommend that you look at the MAIL MERGE functionality
of MS WORD as its designed to accomodate such needs. Among other things,
its entirely possible for Word to query an Access database to pull the
data. Before you explore it, you'll probably want to create a query in
Access to pull the fields for the envelopes based on the specific
criteria that you have. From there, the MM Wizard in Word will do the
bulk of the work.
 
T

Tim Ferguson

Can you point me in the right direction? I want to combine the address
fields into one textbox. Then I want to click a button to create an
envelop. Thank you.
Click to expand...

(Title + " " ) & (FName + " " ) & LName & (" " + Suffix) &
(vbNewLine + AddressLine1 ) &
(vbNewLine + AddressLine2 ) &
(vbNewLine + AddressLine3 ) &
(vbNewLine + PostCode)

This kind of assumes there will always be an LName, but everything else is
optional and will disappear if Null. For explanation, see Help files on
concatenation operators.

Can't remember off hand whether vbNewLine is legal in a ControlSource - you
may have to change them all to chr(13)+chr(10)

Hope that helps.


Tim F
 
Top