J
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
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