Re: Win32:OLE and Word Mail Merge

Word is very picky about datasources for mail merges.

I've done it before using CSV files by:

opening the CSV file using Documents.Open - Word recognises it's a CSV file; used delimiters "," and "<CR>" (no dialog, as these are standard)
saving the CSV as a Word document
using the Word document as the datasource, specifing it's a Word document in the call to MailMerge.OpenDataSource

which actually works without any prompts. But, from your quoted delimiters I take it your not using a standard CSV file, so I doubt this would work. If you're opening a file Word does not recognise, I don't think you can get around the Word dialogs at all. Sorry ;).

Comment on Re: Win32:OLE and Word Mail Merge

Replies are listed 'Best First'.
Re: Re: Win32:OLE and Word Mail Merge by Gerard (Pilgrim) on Oct 16, 2001 at 16:14 UTC
For anyone that is interested, here is my final conclusion... After much searching it seems that there is no way to dowhat I was trying. The only solution that I have come up with is to read the file, change the delimiters etc. and save it to another file. This works fine but is a little annoying as updates etc. have to be made in more than one place... But hey,... It works and I suppose that is all that really matters.	[reply]
Re: Re: Win32:OLE and Word Mail Merge by Gerard (Pilgrim) on Oct 16, 2001 at 10:57 UTC
Thanks for the information. Interesting, but doesn't seem to be avoidable as you say. Perhaps someone else will be able to shed some light. I am stumped!	[reply]