Mail Merge Macro?

Hi Guys,

This might just be a pipe dream but i'll give it a whirl anyway! I'd like to generate a mail merge automatically from my spread sheet. So you click a command button, it highlights all rows (columns A-H) with text (all rows have formulas but most are blank), set as print area, save the spreadsheet then open up a word document (always the same document from the same location) and mail merge with dde from the source spreadsheet (always a different name in different location)

Is this possible? Or can we atleast do the mail merge with a macro? I want it to be super easy to use as alot of people find mail merges fiddley!

I hope you can help