View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevenmckeon[_3_] stevenmckeon[_3_] is offline
external usenet poster
 
Posts: 1
Default One button - Excel to word?

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

--
Message posted from http://www.ExcelForum.com