Populate VBA Form Fields to Word

[Jacob J]

Hi,

I just bought the VBA for Dummies book, and I like to
think of myself as a pretty computer savvy person, but
after I got to chapter 3, I'm like, huh?

Anyway, I definitely welcome the expert advice of the
many gurus that are out therel.

I have a Word document that I have to enter the same
fields every day, then save the file with a new file
name, and email it to someone.

I was thinking today how nice it would be to create a VBA
form that could automate this. Here's what I want to
automate:

--- Step 1 ---
Create a VBA form with text fields that would
automatically populate into a new Word document template
when I click the OK button.

--- Step 2 ---
In addition, I'd like to have a section on there that
would allow me to specify what folder on my computer I'd
like to save this file in, as well as the name of the
file, since each file will have it's own unique file name.

--- Step 3 ---
Once the file has been saved, I would then like for VBA
to send the file to a specified email from a drop down
menu on the same form. (if there is a way to have it send
it through MS Outlook that would be cool!)


I have a file that I've put together already, but it's
very bare bones, and I am new at this...but if you don't
mind taking a look at it, I'd be happy to send it to you.

It's just hard for me to learn this programming stuff
without having a thorough example to look at.

Thanks
Jacob J

 

[Peter Hewett]

Hi Jacob J

You've also posted this message in other News Groups. Please do NOT multipost messages.
People end up wasting time answering a question that's already been answered.

If you believe your message is relevant to more than one News Group then cross-post the
one message to multiple news groups.

HTH + Cheers - Peter

Hi,

I just bought the VBA for Dummies book, and I like to
think of myself as a pretty computer savvy person, but
after I got to chapter 3, I'm like, huh?

Anyway, I definitely welcome the expert advice of the
many gurus that are out therel.

I have a Word document that I have to enter the same
fields every day, then save the file with a new file
name, and email it to someone.

I was thinking today how nice it would be to create a VBA
form that could automate this. Here's what I want to
automate:

--- Step 1 ---
Create a VBA form with text fields that would
automatically populate into a new Word document template
when I click the OK button.

--- Step 2 ---
In addition, I'd like to have a section on there that
would allow me to specify what folder on my computer I'd
like to save this file in, as well as the name of the
file, since each file will have it's own unique file name.

--- Step 3 ---
Once the file has been saved, I would then like for VBA
to send the file to a specified email from a drop down
menu on the same form. (if there is a way to have it send
it through MS Outlook that would be cool!)


I have a file that I've put together already, but it's
very bare bones, and I am new at this...but if you don't
mind taking a look at it, I'd be happy to send it to you.

It's just hard for me to learn this programming stuff
without having a thorough example to look at.

Thanks
Jacob J

HTH + Cheers - Peter

 

[Dawn Crosier]

This series of articles by Dian Chapman should be just exactly what you
need.

http://www.computorcompanion.com/LPMArticle.asp?ID=22
Part 1: Learn to create professional looking forms in Word.
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]
http://www.computorcompanion.com/LPMArticle.asp?ID=46
Part 2: Add Automation to your Word forms.
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]

http://www.computorcompanion.com/LPMArticle.asp?ID=119
Part 3: Learn more VBA (macros) to automate your forms.
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]

http://www.computorcompanion.com/LPMArticle.asp?ID=127
Part 4: Lean how to use dialog boxes in your Word forms.
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]

http://www.computorcompanion.com/LPMArticle.asp?ID=136
Part 5: Connect your AutoForm to a database to save input time and keep
better records!
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]

--
Dawn Crosier
"Education Lasts a Lifetime"

This message was sent to a newsgroup. Please post back to the newsgroup so
all may follow the thread.