Using an ACCESS Query to build labels for nametags

[pgontkovic]

Currently, I use ACCESS to track reservations for various types of events. When I want to make nametags, I download the "attendee" query that I've already set up to EXCEL and then merge into a WORD document. Is there a way to set up in ACCESS so the labels can be printed straight from the database? I've tried, but I can't get the labels to space out properly (EX: 2 across and 6 down) even though I put the correct label # in there. AAARRRGGHH!!

 

[Alansidman]

In word, use the mail merge wizard (for labels) and have the source be a query from Access that lists your attendees.

http://office.microsoft.com/en-us/a...-as-a-mail-merge-data-source-HA001233657.aspx

 

[pgontkovic]

Thank so much for the suggestion. I was hoping that I could do it all within ACCESS, but I just don't think that's going to be possible....at least not that I know of. Thanks again.

 

[Alansidman]

Here is a link on how to do that in A2010. If you are using earlier versions, then google Mailing Labels in Access and several other tutorials will pop up.

 

[pgontkovic]

Thanks so much, I'll look into it.
Have a good day!