quagmire02 All American 44225 Posts user info edit post |
so i have about 150 addresses in a mysql database and i can have them displayed and copied into word (or excel) however i want...i have the template that uses the common avery 5160 template (30 mailing labels per sheet) and all i want to do is take these addresses and insert them into the pre-defined areas on the template
this should be easy...but i can't figure out what format it wants so that it will automatically fill each space on the template with a unique address
it's a long shot, but i was wondering if any of y'all have successfully done this...ideas? 5/23/2010 5:07:27 PM |
qntmfred retired 40601 Posts user info edit post |
^
there's a Mailings tab on Word 2007. do Start Mail Merge -> Labels then do select recipients, pick your excel sheet (or you can query directly against OLDBC) then do Insert Merge Field for each field in the address Then click update labels or preview results
[Edited on May 23, 2010 at 5:16 PM. Reason : rough guide. should be able to figure out from there] 5/23/2010 5:12:00 PM |
quagmire02 All American 44225 Posts user info edit post |
^^ yeah, you'd think so, wouldn't you? i've been working with mail merge for the past 45 minutes and it's being an ass
but never-fucking-mind, i got it NOW
(seriously, i was about to throw this thing out the window and tww was my last ditch effort...now it's working splendidly)
BAH...lock, suspend, delete...i'm in a foul mood
[Edited on May 23, 2010 at 5:20 PM. Reason : but thank y'all for responding...i DO appreciate it ] 5/23/2010 5:15:42 PM |