access 2k3 envelopes mail merge

[Guest]

after entering hundreds of records in a table db such as first and last
names, company, brach, address and so on with the objetive of mail merge this
info on hundreds of envelopes, i found out that my mail merge recipient
columns are not shown the same way i built them on the table, so when i
insert the address block on the envelopes the information is kind of messy or
in great disorder: last names on top, no branch shown and last names at the
end of the zip code even do i go back to the table again and the columns are
in the order they suppouse to .
When i save my work why do i have to save the table as a form ??? and not as
the table that originately was built ?? your time and expertise will be deep
appreciated. Thanksssss in advance.

 

[Arvin Meyer [MVP]]

You can write a query to reorder the data the way you want. Typically, using
a form for data entry allows much more control so that data can be validated
and formed the way you wish. It is not necessary, but preferable. No
professional database developer allows users to enter data directly in
tables.

In any case, you should be able to map your data to the mailmerge.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access