Macro to open word, copy Cell A1, and Paste

[aiwnjoo]

Hi,

I have a spreadsheet with Address and other information on, I want to use a Macro that will open Word and paste a selected cell or range into Word but in a specific area.

Example;

Excel:

Cell A1:A3 contains;

Joe Bloggs
3 Bloggs Close
BB00 0BB

Word:

At the top of the word document there is;

Address Line 1
Address Line 2
Address Line 3

So I want to copy A1:A3, Open a Word Document, and Paste over the Address Line 1-3.

Thanks very much,

 

[shg]

Duplicated at http://www.mrexcel.com/forum/showthread.php?t=581934

 

[aiwnjoo]

That was a mistake as unsure where to post it with it being about Word.

Help would be appreciated.