Access 2003; Possible to export fields into labels for mailing?

Punkrulz

Somewhat eXPerienced
Joined
24 Dec 2001
Messages
790
Hey guys,

For the township we have a very large access database that was recently compiled with updated information. Both sides of the township: Township and PD; want to be able use the list, and automatically go through and generate labels. The list contains many different fields, and two of them have to do with the name and the physical address.

Is there anything that can be done to say, extract the necessary information from the list, and compile it into mailable labels?

Thanks!
 

Punkrulz

Somewhat eXPerienced
Joined
24 Dec 2001
Messages
790
Is that an application? Or a feature through Access 2003? Can you elaborate a bit on that Fitz old buddy old pal?
 

fitz

Woah.. I'm still here?
Political Access
Joined
26 Apr 2004
Messages
4,084
use the mail merge feature built into word and learn how to do a mail merge with external data (the access database) and pull the info out of excel and into a label template that you can print directly onto the labels.
 

Punkrulz

Somewhat eXPerienced
Joined
24 Dec 2001
Messages
790
See, this is why I like you. You're a genius! Just 5 minutes after telling the guy that we may have to go with an outside application, and Friday isn't likely... boom, you give me the end all be all of answers, with a feature I never knew about with Word... I managed to figure out how to convert the DB into excel, use the fields I need it, took some time but figured out how to get the labels to work correctly... that was a learning experience!

But thanks Fitz, yet again, you're the man!
 

fitz

Woah.. I'm still here?
Political Access
Joined
26 Apr 2004
Messages
4,084
you should be able to pull the data directly out of access if you tried.. you might need to setup a DSN and all that. It's been a while since I did a mailmerge out of access data.
 

Punkrulz

Somewhat eXPerienced
Joined
24 Dec 2001
Messages
790
Yeah, well it actually seemed easier for me just to export to Excel, delete the fields I didn't need, and then import from Excel... setting up a DSN and everything I think it's going to be way more hassle than it's worth, especially since we're going to be doing this that often.

But thanks Fitz!
 

Members online

No members online now.

Latest profile posts

Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!
Perris Calderon wrote on Electronic Punk's profile.
EP, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there!

Forum statistics

Threads
61,997
Messages
673,411
Members
5,591
Latest member
nodee