Word macros template, drop down list, save button

Hi all

I have a word document template that, using macros, opens up a new document
containing mail merge values retrieved from the database.

1 I want to specify (in the document template) the name of the template
that the new document opens up in.

2 I want to have a drop down list (in the template toolbar) that lists
values from the database.

3 I want a button that automatically saves the document to a folder on
the users hard drive.


Thanks in advance for any help - greatly appreciated.....

Simon

Doug
Sat Aug 07 18:51:15 CDT 2004

Don't want much do you? I don't understand what you mean in 1. For 2, See
the article "Load a ListBox from a Named Range in Excel using DAO" at:

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm

That works for Access as well with appropriate modifications.

For 3, how do you intend the filename to be supplied for saving the
document?
--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"SimonS" <SimonS@discussions.microsoft.com> wrote in message
news:D6DDFEB2-F865-4634-89EE-E19B9C3B4B2E@microsoft.com...
> Hi all
>
> I have a word document template that, using macros, opens up a new
> document
> containing mail merge values retrieved from the database.
>
> 1 I want to specify (in the document template) the name of the template
> that the new document opens up in.
>
> 2 I want to have a drop down list (in the template toolbar) that lists
> values from the database.
>
> 3 I want a button that automatically saves the document to a folder on
> the users hard drive.
>
>
> Thanks in advance for any help - greatly appreciated.....
>
> Simon
>

SimonS
Wed Aug 11 05:35:03 CDT 2004

thanks for reply Doug.

I'll check out the article for 2. Is it possible to have a drop down list
in the toolbar that contains these values?

for 3:

I will get the name of the document to be saved by using an id from the
database and the current datetime.

for 1:

The thinking behind 1 is that the save button will be in the template that
the new
document (containing the mail merge values retrieved from the database)
opens up in. So therefore in order for this save button to appear in the
document i need to specify the template it opens up in.


Hope this is clear?! thanks again for any help....

Simon


"Doug Robbins" wrote:

> Don't want much do you? I don't understand what you mean in 1. For 2, See
> the article "Load a ListBox from a Named Range in Excel using DAO" at:
>
> http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm
>
> That works for Access as well with appropriate modifications.
>
> For 3, how do you intend the filename to be supplied for saving the
> document?
> --
> Please respond to the Newsgroup for the benefit of others who may be
> interested. Questions sent directly to me will only be answered on a paid
> consulting basis.
>
> Hope this helps,
> Doug Robbins - Word MVP