I have the following data in my email from over 5,000 people who responded for free samples and I can not find away to grab their addreses and put it on labels without copy and paste please anyone help.
The info looks like this ( it my info)
) (Name: Jason Maxpro) (Gender: Male) (Age: 26) (Marital Status: In a relationship) (Condom use: sometimes) (What's your brand?: Maxpro) (Where do you purchase?: drugstores) (How many do you buy?: 12pack) (Would you try a new brand on packaging?: undecided) (Willing to pay for 12?: 12to15) (Household income?: 50kto100k) (Address: 4057 Clipper Court Fremont, CA 94538) (Promo Code: mpwave1) (Email: jason@maxprocondom.com) (Comments/questions:
Their are no spaces it shows just as you see it when I export to excel 1 line shows up the same way as it shows above how can I just get the addresses?
If you can help I will send you a year supply LOL
Say your line of import from outlook is in Cell A1, the following code will grab name and address to B1 and C1, based on that, using mail merge of MS Word will get you the label you want.
Alt-F11 to open VBA editor, right click icon on left to insert a module, click the module and on the right blank area add the following, Alt+F8 then run the macro getNameAddress
Chuck Berry 45 Sweet Little Sixteen/Reelin And Rockin VG+ CHESS 1957 EARLY ROCK , The Hypnotics WLP PROMO 45 Dance to the Music/mono MINT NOS NORTHERN SOUL DJ '73, Sealed! Jazz DUKE ELLINGTON A Tribute To 2LPs Various Artists #g169, Louis Brooks And His Hi-Toppers WLP 45 It's Love Baby/Chicken Shuffle EX- 1955, EMPIRE BAKUBA: Adieu Docteur Nico (rare african vinyl LP), Bobby Long 45 I've been there too/Jenny Lee EX Teia 1001 removable XOL CLEAN R&B, GINO JAMES Popularity / New Girl VG- 45 RPM TEENER DJ PROMO COPY, LONNIE B. & VIKI G. Lovin' Feeling VG+ 45 RPM NORTHERN SOUL PROMO DJ COPY , JOAN BAEZ Best Of Friends VG+(+) 45 RPM DJ PROMO COPY (Mono)/(Stereo), The Sensations 45 Let Me In/Oh Yes I'll Be True EX+ ARGO ORIG BROWN LABEL 50's, Royal Teens 45 Short Shorts/Planet Rock EX/- 1957 ORIG MONO ROCKER Stroll PUNK, The Chordettes WLP ADV TEST PRESSING 45 VG+ Just Between You & Me/Soft Sand 1957, RAY SCOTT - LIVE AT THE PARISIAN ROOM- COMEDY WITH FUNKY BAND -BREAKS - PROMO-NM, VG++ THE CHOICE FOUR HOOK IT UP 1975 45 RPM RCA JH-10210 PROMO COPY, PRIMO PEOPLE-SELF TITLED - ON CAPITOL - PROMO - ORIGINAL, WANDA JACKSON WHAT HAVE WE DONE- PROMO COPY CAPITOL 45 RPM, BRIAN PROTHEROE - PINBALL - PROMO COPY - SINGER SONGWRITER, EDDIE BO: Ain't It The Truth Now (soul vinyl 45), WILLIE NELSON: Red Headed Stranger (country vinyl LP), NOTORIOUS B.I.G.~BIG POPPA (EXPLICIT)~BAD BOY 79016 12" SINGLE EX+/M-, DELEGATION - Oh Honey, SHADYBROOK SD004 12" SINGLE EX/EX+, KAT MANDU - THE BREAK, T.K. DISCO 155 12" SINGLE, PROMO, LEVEL 42 - World Machine, POLYDOR 827 487-1 VINYL LP, EX+/EX, MARVIN GAYE~HELLO BROADWAY~TAMLA 259 MONO LP VG+/VG+, SOUNDTRACK~THE SHOOTING PARTY~VARESE STV 81235 VINYL LP M-, Mike, Penny, and Penny Seeger - American Folk Songs For Christmas - Used Vinyl, Iron Butterfly - Sun And Steel - Used Vinyl, Red Beans & Rice - Live At The Dublin Caslte - Used Vinyl, The Dove Orignal Movie Soundtrack Promo LP E+ Condition Low Opening Bid!, BILLY WALKER*A WOMAN LIKE YOU bw THE STORM WITHIN MY HEART*1959 COLUMBIA PROMO!!, THE WACKERS - SHREDDER - WHITE LABEL PROMO--PSYCH -INSERT, NELSON PINEDO: Sale Caliente Y Coma Callao (latin vinyl LP), YOUTH OF TODAY Can't Close My Eyes LP Schism / Caroline records white + sticker, KISS Special Kiss Album Summer Tour NM! KISS-76 WL PROMO! ORIG RARE! #g130, KEELY SMITH-SING THE BEATLES SONG BOOK -- WHITE LABEL PROMO - MONO, The Beatles - Let It Be - MEXICAN IMPORT - USED Vinyl, Louis Armstrong - Chicago Concert 1956 Live 2xLP - Used Vinyl, EMMA TERANGI: Tahiti Melodies (international vinyl LP), JAKKI: Sun, Sun, Sun (soul vinyl 45), PARRISH & GURVITZ Janine / I've Got Time 45 rpm PROMO Decca 1972 Folk-Pop, JOHN BUZON TRIO -INFERNO -WHITE LABEL PROMO - MONO, Vic Damone Columbia promo LP Closer Than A Kiss, Columbia Y3 35240 Mozart & Beethoven BUDAPEST QUARTET rec.1932-40 NM 3 LPs promo, DEEP PURPLE - THE BEST OF DEEP PURPLE - PROMO VERY RARE - URUGUAY- (4 pics), Elliott Smith LOT of FIVE 7" (figure 8 roman candle xo pete krebs mic city sons), CACTUS WORLD NEWS / U2 ( YEARS LATER ) 1980 12" PROMO lp + NEWSLETTER & PS 45 NM, VG++ FOREIGNER FEELS LIKE THE FIRST TIME 1977 45 RPM ATLANTIC 3394 PROMO COPY, Lucinda Williams World Without Tears +2 2x LP Vinyl NEW, Duran Duran - Is There Something - 7" & 12"- USED Vinyl, SCARS: Author! Author! (rare punk/new wave vinyl LP), VARIOUS: Island Music Of The South Pacific (international vinyl LP), CHER 45rpm record "HEART OF STONE" EX-, VG++ KIM CARNES I'D LIE TO YOU FOR YOUR LOVE 1986 45 RPM EMI P-B-8335 PROMO COPY, MADONNA bad girl /fever 12" HOUSE~PETTIBONE/OSCAR G./& MURK MIXES~0-40793) 1992, The Moore Twins - Rare Promo 45 - "Rosemary" / "It Can Never Be The Same", ROLLING STONES 45rpm record "DANCING WITH MR. D" VG+, PLATTERS 45rpm record "I LOVE YOU 1000 TIMES" GOOD, Columbia M 33927 Lazar BERMAN piano LISZT Sonata promo NM LP 1976, TROGGS 45rpm record "LOVE IS ALL AROUND" VG, BROTHERS JOHNSON: Stomp! (soul vinyl 45),
Eligible for free shipping!
