Question I've set up 3x4 nametags in WORD for a specific event that I track in ACCESS...

pgontkovic

New member
Local time
Today, 03:18
Joined
Jan 14, 2013
Messages
6
Is there a way to set up a "button" that will activate a WORD document that's not in the specific ACCESS database, but on the same drive? I used a download of information to make the nametags, though.
 
I'm confused about what you are trying to do. Are you asking how to use Access to do a Word mailmerge? It would actually be simpler, if you have all the info in Access tables, to just create a report from Access. Access has a label wizard that can help you. If you can't find the exact label size you need, you can create a custom size.
 
I use ACCESS to record event (reunions, Homecoming, etc.) registrations. The information comes from a download of all those on the invitation list plus other pertinent information unique to each individual.

I set up queries (EX: those that have registered, dietary needs, headcount, etc.) that I know will be used and any forms (EX: LOGIN Form) that I know will be used.

With each event, I have to do nametags. Usually I download into EXCEL and merge into WORD. I was initially trying to see if I could set this up ahead of time and provide a button (similar to one where you can open queries, forms or close the application) where someone could push the button and the mailmerge happens and the nametags can be printed.

I was attempting to set this up, because a lot of times I AM NOT the only person taking this information and I didn't want people really "playing" with the tables, since they aren't real sure of what they are doing.
With all that said, I was asking whether a "button" could be setup in ACCESS that would automatically go to a WORD document that was already set up
 
Yes, Access can run a Mailmerge or export to Excel. I don't have any mailmerge code handy - I use automation myself. To export to Excel use the TransferSpreadsheet method. BUT, as I asked before - is there some reason you don't want to just create an Access report to produce the labels?
 

Users who are viewing this thread

Back
Top Bottom