Vb Mail Merging Excel

[ben3001]

Hi all im really screwing my head around this and im sure someone on this forum must no this vb, i can say one thing i certainly dont.I have a spreadsheet and would like to mail merge it at the click of a button. I am fully aware of how to create a mail merge from word to excel but not from excel to word.The main reason for this is user friendliness. I'd rather the user press the button and presto, rather than open word --> make doc --> mail merge --> select fields ...this probably is not the place to post it but this is really wrecking my head and i cant sleep...Thanks for any attempts at a solution