Requested object is not available - automating word mail merge

[John Davy]

I am trying to set up a mail merge by automation using a text file as the
data source but I keep getting the message

"Requested object is not available" and the debugger stops on the
opendatasource line (code below)

(I am VERY new to c# so this is a bit difficult for me at the moment)

I am using win xp and office xp 2003 (word 11)
I have installed the PIA for office as per Microsoft KB

Any help would be appreciated

Cheers
John
-----------------------------------------------------------------------------------------------
private void button1_Click(o bject sender, System.EventArg s e)
{
Word.Applicatio n wrdApp;
Word._Document wrdDoc;
Word.MailMerge wrdMailMerge;
Object oMissing = System.Reflecti on.Missing.Valu e;
Object oFalse = false;
Object oTrue = true;
Object oFormat = 0;
Object oNul = null;
String cTextFile = "d:\netmerge\te st.txt";
Object oDocName = "test.doc";

// Create an instance of Word and make it visible.
wrdApp = new Word.Applicatio n();
wrdApp.Visible = true;

// Add a new document.
wrdDoc = wrdApp.Document s.Add(ref oMissing,ref oMissing,ref oMissing,ref
oMissing);
wrdDoc.SaveAs(r ef oDocName,ref oMissing,ref oMissing,ref oMissing,ref
oFalse,ref oMissing,ref oMissing,ref oMissing,ref oMissing,ref oMissing,ref
oMissing,ref oMissing,ref oMissing,ref oMissing,ref oMissing,ref oMissing);
wrdDoc.Select() ;

// Set Up Mail Merge
wrdMailMerge = wrdDoc.MailMerg e;
wrdMailMerge.De stination = Word.WdMailMerg eDestination.wd SendToPrinter;

//Connect to data
/* OpenDataSource parameters
TableName ,
Format ,
ConfirmConversi ons ,
ReadOnly ,
LinkToSource ,
AddToRecentFile s ,
PasswordDocumen t ,
PasswordTemplat e ,
Revert ,
WritePasswordDo cument ,
WritePasswordTe mplate ,
Connection ,
SQLStatement ,
SQLStatement1 ,
OpenExclusive ,
SubType
*/

//problem ooccurs here
wrdMailMerge.Op enDataSource(cT extFile,ref oFormat,ref oFalse,ref oFalse,ref
oTrue,ref oFalse,ref oNul,ref oNul,
ref oFalse,ref oNul,ref oNul,ref oNul,ref oNul,ref oNul,ref oFalse,ref
oNul) ;

//Perform mail merge.
wrdMailMerge.Ex ecute(ref oFalse);

// Close the original form document.
wrdDoc.Saved = true;
wrdDoc.Close(re f oFalse,ref oMissing,ref oMissing);

// Release References.
wrdMailMerge = null;
wrdDoc = null;
wrdApp = null;
}

[doug mansell]

just guessing...but try changing this line:

String cTextFile = "d:\netmerge\te st.txt";

to

String cTextFile = "d:\\netmerge\\ test.txt";

John Davy wrote:

I am trying to set up a mail merge by automation using a text file as the
data source but I keep getting the message

"Requested object is not available" and the debugger stops on the
opendatasource line (code below)

(I am VERY new to c# so this is a bit difficult for me at the moment)

I am using win xp and office xp 2003 (word 11)
I have installed the PIA for office as per Microsoft KB

Any help would be appreciated

Cheers
John
-----------------------------------------------------------------------------------------------
private void button1_Click(o bject sender, System.EventArg s e)
{
Word.Applicatio n wrdApp;
Word._Document wrdDoc;
Word.MailMerge wrdMailMerge;
Object oMissing = System.Reflecti on.Missing.Valu e;
Object oFalse = false;
Object oTrue = true;
Object oFormat = 0;
Object oNul = null;
String cTextFile = "d:\netmerge\te st.txt";
Object oDocName = "test.doc";

// Create an instance of Word and make it visible.
wrdApp = new Word.Applicatio n();
wrdApp.Visible = true;

// Add a new document.
wrdDoc = wrdApp.Document s.Add(ref oMissing,ref oMissing,ref oMissing,ref
oMissing);
wrdDoc.SaveAs(r ef oDocName,ref oMissing,ref oMissing,ref oMissing,ref
oFalse,ref oMissing,ref oMissing,ref oMissing,ref oMissing,ref oMissing,ref
oMissing,ref oMissing,ref oMissing,ref oMissing,ref oMissing,ref oMissing);
wrdDoc.Select() ;

// Set Up Mail Merge
wrdMailMerge = wrdDoc.MailMerg e;
wrdMailMerge.De stination = Word.WdMailMerg eDestination.wd SendToPrinter;

//Connect to data
/* OpenDataSource parameters
TableName ,
Format ,
ConfirmConversi ons ,
ReadOnly ,
LinkToSource ,
AddToRecentFile s ,
PasswordDocumen t ,
PasswordTemplat e ,
Revert ,
WritePasswordDo cument ,
WritePasswordTe mplate ,
Connection ,
SQLStatement ,
SQLStatement1 ,
OpenExclusive ,
SubType
*/

//problem ooccurs here
wrdMailMerge.Op enDataSource(cT extFile,ref oFormat,ref oFalse,ref oFalse,ref
oTrue,ref oFalse,ref oNul,ref oNul,
ref oFalse,ref oNul,ref oNul,ref oNul,ref oNul,ref oNul,ref oFalse,ref
oNul) ;

//Perform mail merge.
wrdMailMerge.Ex ecute(ref oFalse);

// Close the original form document.
wrdDoc.Saved = true;
wrdDoc.Close(re f oFalse,ref oMissing,ref oMissing);

// Release References.
wrdMailMerge = null;
wrdDoc = null;
wrdApp = null;
}