 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming VBA / January 2008Searching for Outlook 2007 VBA Consulting
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. 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.  SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > Hi Everyone: > [quoted text clipped - 31 lines] > > I probably developed the original macro in 2 hours the first time. 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. > 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. > [quoted text clipped - 35 lines] > > > > I probably developed the original macro in 2 hours the first time. > 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. SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > 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 [quoted text clipped - 17 lines] >> >> 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. >> > Hi Everyone: >> > [quoted text clipped - 31 lines] >> > >> > I probably developed the original macro in 2 hours the first time. 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. > > With Outlook > > 2003 there was the "record macro" feature that I used heavily in the creation [quoted text clipped - 59 lines] > >> > > >> > I probably developed the original macro in 2 hours the first time. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.