Converting Acess data to use to print names and addresses on envel

L

lindabelll

I want to be able to convert my names and addresses in Access to Word so I
can print, let's say, my Christmas cards. Can this conversion be done? The
names will have to be repositioned so they read first name first, last name
last. Can someone help me???
 
M

Micah Chaney

How are the fields currently stored in Access? Are First Name, Last Name two
different fields, or is there just one Name field. Also Did you know you can
do a mailmerge type action within Access utilizing the Reports and Query
features? I'm sure there's a way to mail merge Word using Access data, but
if worse comes to worst, just export your table to Excel, and do your
conventional mail merge. Hope this helps.
 
L

lindabelll

Thanks Micah. There are two fields, last name, and first name. When
converting them they would have to be reversed in word to print properly on
the envelope.
 
M

Micah Chaney

This isn't really an Access question. But I can help you anyway. Do you
have your labels or whatever already created in Word? If so good. If not do
that first. Second, you'll want to do Mail Merge. Depending on what version
of Office you're using (2000, 2003, etc) you can choose where your "source
data" or "recipients" come from. When you get to this step, instead of
choosing Outlook or Excel, you'd browse and find your Access database.
Choose your table, follow the prompts and you should be able to choose only
the fields you want to display and what order you want to display them. Let
me know if this helps.
 
L

lindabelll

OMG....thanks....that's just what I needed...I've been going nuts trying to
do the conversion thru Access instead of Word.....Thanks again.
 
M

MyrtG

I know this is an old topic, but my question is: why do I have to use an
Access table?
I want to use an Access query. In the past with MS 2000, we mail-merged
labels with queries regularly. Now I have MS XP and all that shows up are
the tables..........? I can't use a query anymore to just create labels for
a specific group for which I already have a query?
 
Top