Automatically copy a table, open and email and add the Tbale.

[Outswing]

Hi All,

Am working in Excel 07, but this would need to work in 2000 as well.

Can anyone help with the following. Need a macro that will...
1. Select a range of cells from B4 to RX. X is defined as the last row where Column A has a value.
2. Copy the visible cells
3. Open an email, enter "Submission" into the title, enter "Dear X," insert 2 returns.
4.Paste the copied table into the body the email.

Many Thanks
Outswing

 

[shg]

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

 

[Outswing]

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

Any help? Or just picking up mistakes by users?