Outlook - Excel Macros

[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 M. Schorr, MVP]

You'd need to do some VBA coding to do that in Excel or Outlook.

Might actually be easier to use a 3rd party tool like AutoHotkey
(http://www.autohotkey.com) to script it.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com/outlook.html
Author: The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/ol4law-amazon

 

[Michael Bauer [MVP - Outlook]]

This example might help you getting started:
http://www.vboffice.net/sample.html?lang=en&mnu=2&smp=41&cmd=showitem

For more VBA/macro questions please visit
microsoft.public.outlook.program_vba

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


Am Wed, 17 Mar 2010 17:53:01 -0700 schrieb dhstein:

 

[dhstein]

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

 

[Michael Bauer [MVP - Outlook]]

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: