Table from Excel into Outlook

  • Thread starter Thread starter iambalrog
  • Start date Start date
I

iambalrog

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!!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
How do I prevent an excel attachment being forwarded on by email? 2
Getting information from access table in excel 1
Pivot table code question 2
Excel to Word to Outlook 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Importing Word tables into Excel 4
Mail Merge in Excel 1

Back
Top