Mail Merg doesnt work need VBA solution

[mmikem]

Hi All

I have being trying to do a mail merg to word so I can print address labels So far I can get Name or address but not a complete label

I have First/Last Name in column B4:B203 Column G4:G203 is address Column H4:H203 is province and column I4:I203 is Postal code on sheet 1

I would like a macro button in excel when I push opens word then set up my address labels

any thoughts or help

thanks

[macropod]

A label merge from Word has no trouble picking up all the Excel data if the setup is done correctly. No code required. Simply saying "Mail Merg doesnt work" and "So far I can get Name or address but not a complete label" is hardly conducive to solving the problem...