Outlook - Excel Macros

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

I have an Excel spreadsheet - and every day I have to copy the data to an
email. I'd like to create a macro that pulls the subject from cell G7,
copies the range of data from cells A15:B100 for example then pastes special
formatted text into the email body and puts a specific name into the "To"
field. I'm comfortable with Excel macros but close to clueless with Outlook
macros. Would this be done from Outlook or from Excel or what? Any help is
appreciated.
 
Ben, Michael,
Thanks for your help. I can start with that example which copies to word.
Now I just need to figure out how to refer to fields in Outlook in VBA. So
that I can paste into the "To" field, the Subject field and the Body of the
email.

David
 
It doesn't copy to Word, but Word must be the email editor for Outlook else
you wouldn't get the table formatted.

In the example Application.ActiveInspector returns a reference to the
current email, which has the desired properties (Subject etc.)

--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?lang=en>


Am Thu, 18 Mar 2010 18:52:01 -0700 schrieb dhstein:
 
Back
Top