Automating Word from VBScript

[RMittelman]

Hi,

Not sure if this forum is the correct place, please advise if there is a better forum.

I'm trying to print an envelope by automating MS Word. This works fine for me in Access VBA, but having problems with VBScript. Here is my code, modified to work in VBScript:

Dim wd, Doc
Set wd = CreateObject("Word.Application")
wd.Visible = False
Set Doc = wd.Documents.Add
Doc.Envelope.PrintOut , fullAddress, , , retAddress
Doc.Close False
Set Doc = Nothing
Set wd = Nothing

Note fullAddress and retAddress were set previously, and contain text and VbCrLf's.

The PrintOut method results in a type mismatch error.
The documentation says:

expression.PrintOut (ExtractAddress, Address, AutoText, OmitReturnAddress, ReturnAddress, ReturnAutoText, PrintBarCode, PrintFIMA, Size, Height, Width, FeedSource, AddressFromLeft, AddressFromTop, ReturnAddressFromLeft, ReturnAddressFromTop, DefaultFaceUp, DefaultOrientation, PrintEPostage, Vertical, RecipientNamefromLeft, RecipientNamefromTop, RecipientPostalfromLeft, RecipientPostalfromTop, SenderNamefromLeft, SenderNamefromTop, SenderPostalfromLeft, SenderPostalfromTop)

Note that Address is the second parameter and ReturnAddress is the 5th parameter. VBScript doesn't allow named parameters, so I had to use the commas to place the needed parameters in the correct position.

If I move the return address to the 4th position by removing a comma, it all works. I understand the return address won't print because I did not send it in the proper position. But why do I get a type mismatch with it in the right position?

Any ideas what is going wrong?

[ranman256]

The doc may not have an envelope in it.
did you open a file (doc) with an envelope in it?

[RMittelman]

The doc may not have an envelope in it.
did you open a file (doc) with an envelope in it?

Thanks for the reply, but it does have an envelope. The code creates a new document then adds an envelope to it. This code works properly in Access.
Also, the envelope does in fact print out if I move the return address up higher in the field list by deleting the comma just before the return address. Of course, this puts the return address into a boolean field called OmitReturnAddress. I can see why this causes the return address to not print. But the envelope does in fact print out. But if I put the return address in the correct position in the field list, it causes the type mismatch error.

[Welshgasman]

Do you have a comma in the fields, before returnaddress?

[RMittelman]

Do you have a comma in the fields, before returnaddress?

Yes, I do. Compare the program statement with the example of what fields are available from the documentation. Both of these are in my original post.

[Welshgasman]

No! :-(
I mean does fullAddress have a comma in it?
That might confuse word?

[RMittelman]

No! :-(
I mean does fullAddress have a comma in it?
That might confuse word?

Oh, sorry. The addresses do indeed have commas as expected. However, I don't think that's the issue, because the destination address prints properly, commas and all.
Both addresses have commas between the city & state.