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

Punkrulz

Somewhat eXPerienced
#1
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
#3
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?
Staff member
Political User
#4
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
#5
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?
Staff member
Political User
#6
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
#7
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 posts

Latest profile posts

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 https://tinyurl.com/ycpxl
Electronic Punk wrote on Perris Calderon's profile.
All good still mate?
Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,971
Messages
673,300
Members
89,016
Latest member
Poseeut