Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re: Win32:OLE and Word Mail Merge

by zakb (Pilgrim)
on Oct 16, 2001 at 10:38 UTC ( #119073=note: print w/replies, xml ) Need Help??

in reply to 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 ;).

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

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://119073]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (2)
As of 2022-09-30 00:52 GMT
Find Nodes?
    Voting Booth?
    I prefer my indexes to start at:

    Results (125 votes). Check out past polls.