Question Locked

How to make a macro in outlook 2007...need a code sample :)

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How to make a macro in outlook 2007...need a code sample :)
Hi to all.
I'm looking for a code sample (VSBA )capable to insert a text message, when replying to a mails. Many times I get many mails that needs the same answer, and I think it will be easy for me not to write the same message again and again, or make a copy-paste in mail reply.I think that it should be possibile to have a macro for outlook 2007 that can solve this issue. Can you help me with this "macro"?.
I thank you very much

6 replies

by rob mekel

There is an easier way to do this.

Start your outlook, click on extra and find the item "rules and warnings" and there you go.

by alfnic

Thank you for your solution. It is very good solution if you recieve same mails with the same word on it. If so, then rules, based on specific words can easy be made and the automatic mail reply can solve the problem. But the scenario is my case is different, because I have (1)to read the mail in order to decide (2)wich answer mailtext should be placed in that particular mail, and (3) reply with the appropriate text.The macro it will make more easy to me to choose the rigth mail text, or if you want we can call text template.
This was possible with outlook 2003, because I had the possibilities to create a macro, and after reading the mail, I could choose the right macro to that specific mail.
I kindly appreciate your help, but I have some doubt in your "rules and warnings" solution.
Regards.

by toleary

Outlook 2007 came up with Quick Parts. I think that is what you're looking for.
"Add a new Quick Part for email messages
Quick Parts are a new Word and Outlook 2007 feature for text fragments and other building blocks, replacing the AutoText feature in previous versions. Here?s how you can create a Quick Part to hold boilerplate text for insertion in an email message.

Open a new Outlook message.
Write the boilerplate text you want to be able to reuse.
Select all that text, and then choose Insert | Quick Parts | Save Selection to Quick Part Gallery.
In the Create New Building Block dialog, give the Quick Part a name and set the other options. Do not change the gallery from Quick Parts to something else.
Click OK to save the new part.
To test your new Quick Part:

Choose Insert | Quick Parts, and select the name of the part you just created.
Outlook saves the Quick Part in the NormalEmail.dotm file, a template used for email messages that also can contain your custom Quick Style settings."

Tim

by alfnic

Hi Tim,
thank you very much for your efforts. That?s the solution that I was looking for. Many thanks for your help.
Kind regards.
Alfredo

This discussion is closed to new replies.