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

MAIL MERGE

5/23/2010 5:07:59 PM

^

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

^^ 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