One button - Excel to word?

[stevenmckeon]

Hi All,

I have put together a multi sheet pricing list to build a produc
quote. I need to provide end users with a Macro button that will expor
the collected data into a mail merge styled Word document so they ca
then save the quote in there records.

Simply I would like to send data like this

Cell A1 - 3
Cell B1 - Widgets
Cell C1 - $8000

to a word document (pre formated quote) containing

<< Number >> << Product Name>> << Price >>

style merge fields.

Is this possible?

Any help appreciated.

Stev

 

[Dave R]

I am working on a similar problem. If I find out how I`ll let you know.

Regards,

Dave

P.S. This is a workaround, not as effective as a word mail merg
http://www.j-walk.com/ss/excel/tips/tip92.htm

P.P.S This might be useful as well

 

[Dave R]

2nd time lucky this might me useful as wel
-http://www.mrexcel.com/tip014.shtm