LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Table from Excel into Outlook


I have a table in excel using cells say A10:F20 on Sheet1.

I want to be able to make a macro that picks up this table, and copie
it into an email in ms outlook after some text.

i.e.
"Dear All
please find attached this months business report. The summary detai
is as such:
xxxINSERT TABLE HERExxx

Please do not hesitate to contact me if i can be of any mor
assistance.
Thanks
Tim"

The recipitents of the email will be standard, and the location of th
file would be standard too. The macro would need to compose the email
fill in the recipitents/subject line, add in the table, and sen
itself.
I know you guys can help!!!

--
iambalro
-----------------------------------------------------------------------
iambalrog's Profile: http://www.excelforum.com/member.php...fo&userid=2697
View this thread: http://www.excelforum.com/showthread.php?threadid=57074

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002: How to convert MS Outlook table back to numbers ? Mr. Low Excel Discussion (Misc queries) 0 February 18th 09 12:56 PM
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 Stuart[_4_] Excel Discussion (Misc queries) 2 October 6th 08 05:07 PM
sync between table in excel to task list in outlook ayelet Excel Discussion (Misc queries) 0 August 31st 08 06:19 AM
excel open in outlook if outlook is running kirk Excel Discussion (Misc queries) 0 May 24th 06 06:42 PM
Late Binding to Outlook from Excel: Outlook modifies email body Lenny Wintfeld Excel Programming 0 December 12th 04 04:03 PM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"