Autonew macro in Word to select specific record from Excel databas

[Nightowl4933]

Hi,
I'm trying to automate a procedure where a document based on a specific
template, asks for a value from a specific field in a database so that only
that record will be merged into the document based on that template. I'm
using Office 2003 but would prefer it to work in Office 2002 as well.

Basically, the spreadsheet is the data for a mailmerge document and I'm
using the InputBox function to retrieve the record that matches the search
string (which can only be a 5-digit number) from the "IDCode" field in
"Database.xls" in the "C:\Database" folder. I have a number of other fields
within the template that are populated from the database.

TIA,

Pete

 

[Doug Robbins - Word MVP]

See answer to your identical post in the mailmerge.fields newsgroup. Please
do not post the same question separately to multiple newsgroups. Rather, if
you think that you have more chance of getting a response, put the names of
all of the newsgroups in the header of the one message. The reasons for
this are as follows:

1. A response in one newsgroup will then appear in all of the newsgroups
to which you posted the message
2. That will make it easier for you to find the response
3. It will allow people who see your post to see that it has already
received a response and save them going to the trouble of creating a
response themselves.


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