Building a tool for managing the meeting's minutes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Franz976 - 20 Jun 2005 10:37 GMT

Hi,
my company asked me to implement a tool for managing the minutes of the
several meetings we currently hold. The final user of this tool is who will
record the proceeding of the meetings.

The tool have to be developed on Word, of course, and in the end it should
give the opportunity to the end-user to add several informations (on
different tables) taken from the ERP database (SqlServer).

I thought to the mailmerge functionaly, but i'm still in doubt. I don't
know, for example, if it's possibile to use different fields from different
tables, or if you have to use just one table.

I can also use Macros and VBA... Does any one know which would be the best
way to accomplish my goal?

Thanx in advance, and please excuse my bad english!
Francesco

Reply to this Message

Doug Robbins - 20 Jun 2005 19:00 GMT

I am not sure that mailmerge is the right tool for this. Tell us more about
the several informations (on
different tables) taken from the ERP database (SqlServer)

What sort of information is it? Is it just information taken from a single
record (and the corresponding (linked) records in the other tables?

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
> my company asked me to implement a tool for managing the minutes of the
[quoted text clipped - 16 lines]
> Thanx in advance, and please excuse my bad english!
> Francesco

Reply to this Message

Franz976 - 21 Jun 2005 07:45 GMT

Hi Doug

thanks for replying. No, we have a lot of tables not always related; for
example:
- resources table
- projects table
- customers table
- ecc

Even if related, there is often the 1:n relationship between them.

Someone told me to use the bookmarks function: does it really help?

"Doug Robbins" ha scritto:

> I am not sure that mailmerge is the right tool for this. Tell us more about
> the several informations (on
[quoted text clipped - 23 lines]
> > Thanx in advance, and please excuse my bad english!
> > Francesco

Reply to this Message

Doug Robbins - 21 Jun 2005 19:13 GMT

I would say that rules out the use of mailmerge. You may want to take a
look at:

"How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

"Access a database and insert into a Word document the data that you find
there" at:

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi Doug
>
[quoted text clipped - 42 lines]
>> > Thanx in advance, and please excuse my bad english!
>> > Francesco

Reply to this Message