Mailing lists from Access

[Dudley Smith]

I have customers who want to do a mailing from their
access files and do not know how to give me just the
name, address, city,state,zip. I get a file with 15 other
categories and can't seem to be able to delete these
items in my mailing software. Is there a way for them
just to send me those 5 items out of their 10-20 they
have in their database?

Thanks,
Dudley Smith

 

[Jeff Boyce]

Called a query. Sounds like they're sending the whole table.

Good luck

Jeff Boyce
<Access MVP>

 

[kevin watkins]

Dudley,

If you have a mailmerge template in word you can use the
tools in Access to do the mailing . If you use the Merge
it with MS Word feature you get a wizard that allows you
to either attach the template, or create a mail merge
document that uses either a query or table in access. if
this is not the direction you want to go they can use the
query wizard to create a query that gets just the info you
want and then export that wizard to excell. You can then
use the excel file to do what you want.