How do I combine table fields to pass to a Mail Merge

[Guest]

How can I combine different elements of an address in lines of an address for
a mail merge. eg Sometimes a house is combined with street and other times
on a separate line. I can do on aform with Expression Builder but want to
pass out to Word. I would prefer to do it on entry in a Table.

 

[Steve]

You want to keep elements of an address separate in a table. For example,
City, State and Zipcode should be separate felds. You can combine these in a
mail merge by basing the mail merge on a query and using a calculated field
in the query such as:
CityStateZip:[City] & ", " & [State] & " " & [Zipcode]

 

[Jeff Boyce]

Your table can store the individual elements. Use a query to combine pieces
together however you want, then export the query (Access exports the query's
result set) to a Word merge data document (.txt).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[StopThisAdvertising]

"Steve" <[email protected]> schreef in bericht
--

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1150 users have come to me from the newsgroups requesting help '1150 users ????
(e-mail address removed)

--
To Steve:
Over 525!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R