Find the range of a table & copy/past into body of an Outlook email

**JamesGilchrist** · 04-12-2011, 03:26 AM

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 in Outlook (not via the email workbook function of excel), enter "Submission" into the title, enter "Dear X," insert 2 returns.
4. Paste the copied table (not the workbook, just what is on the clipboard) into the body the email.

Many Thanks

**Geethakrishnaraj** · 04-12-2011, 03:44 AM

James, Try with this macro

Please Login or Register  to view this content.

**JamesGilchrist** · 04-12-2011, 03:50 AM

Thanks for getting back to me....but that is way over my head! Ts there a simpler method, I am not a coder I just record and edit the odd excel macro!

**romperstomper** · 04-12-2011, 03:58 AM

@Geethakrishnaraj,
Please learn to use code tags when posting code. I have added them for you on this occasion as it's only your second post, but please use them in future.