T
Trev
I am working for a client on SQL Server 2000. They have an urgent
requirement regarding Mail Merge and I simply do not have the knowledge to
help. Here is the problem as sent to me, can anyone assist (apparently it
worked fine from ASP with Office 2000) :
I am looking for someone to solve the problem described under 'Requirement'
below:
Database: SQL 2000
Contains 2 tables with data:
TableA: contains all the data
TableB: contains 2 fields: Field1: Unique Identifier to line in TableA
Field2: Staff Number
Staff select records to be mail merged using a search and select process
through our Intranet. Their selection list is recorded in TableB. This Table
is then joined to TableA for the merge (ie in a View)
Requirement:
To mail merge the selection list against their staff number into Word 2003
using a selected template (we could end up with several different template
layouts).
Several staff could be using the system at the same time.
I need this to be as automated as possible. Staff using the system should
not have to go through the mail merge system currently offered in Word 2003.
Ideally they should be able to select a template, click on it, type in their
staff number and then the mail merge should be automatic from that point to
delivering the result in Word.
The mail-merge also needs to deal with a couple of conditional if
statements, based on a confidential indicator (values 0 – 4), two fields can
either be shown or not dependant of the Indicator value.
Pointers of assistance greatly appreciated.
TIA
Trev
requirement regarding Mail Merge and I simply do not have the knowledge to
help. Here is the problem as sent to me, can anyone assist (apparently it
worked fine from ASP with Office 2000) :
I am looking for someone to solve the problem described under 'Requirement'
below:
Database: SQL 2000
Contains 2 tables with data:
TableA: contains all the data
TableB: contains 2 fields: Field1: Unique Identifier to line in TableA
Field2: Staff Number
Staff select records to be mail merged using a search and select process
through our Intranet. Their selection list is recorded in TableB. This Table
is then joined to TableA for the merge (ie in a View)
Requirement:
To mail merge the selection list against their staff number into Word 2003
using a selected template (we could end up with several different template
layouts).
Several staff could be using the system at the same time.
I need this to be as automated as possible. Staff using the system should
not have to go through the mail merge system currently offered in Word 2003.
Ideally they should be able to select a template, click on it, type in their
staff number and then the mail merge should be automatic from that point to
delivering the result in Word.
The mail-merge also needs to deal with a couple of conditional if
statements, based on a confidential indicator (values 0 – 4), two fields can
either be shown or not dependant of the Indicator value.
Pointers of assistance greatly appreciated.
TIA
Trev