Searching for Outlook 2007 VBA Consulting

[Dallin Jewell]

Hi Everyone:

I'm looking for someone who can develop a quoting macro that already works
for Outlook 2003. I consider myself a poweruser and can do basic scripting
activities. However, with the change in scripting format in Outlook 2007, I
do not have the knowledge needed to recreate an existing macro that works in
Outlook 2003.

WHAT THE MACRO DOES
In a response email, graps a set of highlighted text buried in one of the
messages from a previous sender, copies it to memory, returns to the current
end of the response email (up top) and inserts:
1) The highlighted text into a quote box that is indented, colored, boxed,
shrinked.
2) The email address and name of the person who wrote the text

The cursor then returns to a spot immediately after the quote.

ITS PURPOSE
To quickly grab a set of text that someone else wrote, bring up to the
response email, format it for easy reading, and then prepare a space for a
prepared response. I programmed this macro to kick off on a keyboard
command, typically CTRL-M.

REQUIREMENTS
- Needed Word as the email editor.
- My email needed to have a signature that would have unique text. The
macro would insert the copied text in a quote box "right above" the signature.

THE CHALLENGE
Outlook 2007 changes the model and doesn't seem to make it easy to figure
out how to copy / paste. I'm looking for anyone who can either develop this
(will pay), or give the guidance to help develop it.

I probably developed the original macro in 2 hours the first time.

 

[Sue Mosher [MVP-Outlook]]

Since Outlook 2007 always uses Word as the email editor, it should actually be easier. If you shared where you're stuck, I bet someone could help get you unstuck.

If not, you can send a message to outlook-dev-hire at yahoogroups.com with details of your requirements, including the Outlook version(s) to be supported. Once the moderator approves your message, Outlook developers on the outlook-dev-hire list can respond directly to you if they're interested in your project.

 

[Dallin Jewell]

Thanks, Sue. Before coming to these newsgroups, I had come across your site.
I almost sent you a personal query there, but figured that newsgroups was
the better open approach.

It was a couple months ago when I attempted to recreate the macro. In
theory, it should be duplicated, but the macro model is entirely different,
and I'm not that familiar with the Outlook object vernacular. With Outlook
2003 there was the "record macro" feature that I used heavily in the creation
of my macro. I was able to learn the code for commands by recording a short
macro that performed the simple task that I wanted to perform. After getting
the raw fundamentals in place, was able to write the rest of the macro.

With Outlook 2007, the lexicon was so different, couldn't even figure out
the most basic fundamentals, and without the record a macro option, couldn't
use my idiot's approach to macro creation.

I'll send off a note to the Yahoo alias to seek out some additional help.

 

[Sue Mosher [MVP-Outlook]]

With Outlook

2003 there was the "record macro" feature that I used heavily in the creation
of my macro.

Outlook has never had a macro recorder. What you used was the Word macro recorder. I've posted some how-to information at http://turtleflock-ol2007.spaces.live.com/blog/cns!C1013F1F9A99E3D8!579.entry on the changes needed to use a Word-recorded macro in Outlook 2007 VBA.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[Dallin Jewell]

Oh, now that just looks luscious. I'll give that a shot on my next long
airplane flight ... and with 5 international trips this quarter, that could
be sooner than later.