Email a Merged Worksheet or just required cells
 

XP Prof. Office 2003 Please help; I have created a Purchase Order Workbook.
Two worksheets; ws1 holds the spreadsheet information (which is entered via a
Userform). ws2 Is a friendly, easy layout form which shows one selected order
looks like a paper order & simply calls the cell information from ws1 by row
(unique No.). I can print this information (B8:L34) and everything works
well. I would like to be able to email an order and as you can simply do
this by viewing the desired order, selecting "file/send to/mail
recipient/this sheet only" I would think that creating a command button could
automate this. But it will not copy, duplicate, attach, send the merged
cells. I have tried several bits of code (Ron DeBruin, this site & others)
but either I get the whole workbook or I get just an empty layout form. Don't
mind email or attachment - just would like to have the whole package.
Suppliers email can be added later. Thank You in advance

Email a Merged Worksheet or just required cells
 

Hi Madmerge

Merged cells is always trouble

Use Center Across selection instead


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Madmerge" wrote in message ...
XP Prof. Office 2003 Please help; I have created a Purchase Order Workbook.
Two worksheets; ws1 holds the spreadsheet information (which is entered via a
Userform). ws2 Is a friendly, easy layout form which shows one selected order
looks like a paper order & simply calls the cell information from ws1 by row
(unique No.). I can print this information (B8:L34) and everything works
well. I would like to be able to email an order and as you can simply do
this by viewing the desired order, selecting "file/send to/mail
recipient/this sheet only" I would think that creating a command button could
automate this. But it will not copy, duplicate, attach, send the merged
cells. I have tried several bits of code (Ron DeBruin, this site & others)
but either I get the whole workbook or I get just an empty layout form. Don't
mind email or attachment - just would like to have the whole package.
Suppliers email can be added later. Thank You in advance