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 |
One button - Excel to word?
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 -- Message posted from http://www.ExcelForum.com |
One button - Excel to word?
2nd time lucky this might me useful as wel
-http://www.mrexcel.com/tip014.shtm -- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com