Need help creating a macro

D

db@Metro

I have created an MS Word fill-in form that can be filled out within the
browser by members of my work group from our Intranet site. In stead of
teaching everyone how to save, rename insert into an outlook message and send
to the desired recipient, I'd like to have a "submit" button that did all
that with a macro. Trouble is, I have no clue how to do it. I have a
minimal understanding of macros...mostly that they exist and do great things.
I know that you can record them from within Word, but I got nowhere when I
tried. Anybody out there able to point me in the right direction? Any
chance I'm not the first one to want this and there's already one out there
that could be tailored to my use?
 
S

Shauna Kelly

Hi

This will tell you how to send an email from Word:

How to send an email from Word using VBA
http://www.mvps.org/word/FAQs/InterDev/SendMail.htm


But you might need these to get you going first:

Getting To Grips With VBA Basics In 15 Minutes
http://www.mvps.org/word/FAQs/MacrosVBA/VBABasicsIn15Mins.htm

Creating a macro with no programming experience using the recorder
http://www.mvps.org/word/FAQs/MacrosVBA/UsingRecorder.htm

Idiots' Guide to Installing Macros
http://www.gmayor.com/installing_macro.htm

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top