> I'm working on a mail merge process that will be started in Access.
> When users click a button, they follow a hyperlink to a letter that
> has been saved as a mail merge document with the merge fields and Data
> Source already set.  It is password protected so users can't save
> changes to it.

> When the document opens, I'd like it to:
> 1. Open read only without a prompt (assuming I can hold down shift to
> get into it for edits when I need to).
> 2. Mail merge to a new document
> 3. Close the original document without prompting a save.

> Can anyone help me?  I am clueless about coding in Word.

> The reason you get no anser is probably because nobody can provide one. This
> may be in part at least because the description is not sufficiently clear.
> (It may also have something to to with the fact that the volunteers helping
> here have limited time, and usually prefer to spend it helping somebody who
> has made a start by themselves and got stuck, rather than somebody asking
> for a complete solution to be provided to them.)

> Can I suggest that, as a first attempt, you record a macro, and see whether
> that does what you need. If there are points on which the recorded macro
> doesn't do what you want, experiment with the code and see if you can tweak
> it to do it right. If you get stuck, post the relevant parts of the code you
> have so far, and somebody should then be in a position to help.

> --
> Regards
> Jonathan West - Word MVP
> MultiLinker - Automated generation of hyperlinks in Word
> Conversion to PDF & HTML
> http://www.multilinker.com
> Word FAQs at http://www.multilinker.com/wordfaq
> Please post any follow-up in the newsgroup. I do not reply to Word questions
> by email

> > Sorry to be a pest, but I've had no replies and I've posted twice.  If
> > I'm asking this on the wrong forum, please advise me.

> > I'm working on a mail merge process that will be started in Access.
> > When users click a button, they follow a hyperlink to a letter that
> > has been saved as a mail merge document with the merge fields and Data
> > Source already set.  It is password protected so users can't save
> > changes to it.

> > When the document opens, I'd like it to:
> > 1. Open read only without a prompt (assuming I can hold down shift to
> > get into it for edits when I need to).
> > 2. Mail merge to a new document
> > 3. Close the original document without prompting a save.

> > Can anyone help me?  I am clueless about coding in Word.

> 1. Open read only without a prompt (assuming I can hold down shift to
> get into it for edits when I need to).

> Any takers out there?

> > OK, sorry if I gave the impression I'm trying to avoid work.  I've done a
> lot of
> > the preliminary to this in Access.  And honestly, I'm simply unaware of
> where to
> > begin on the Word side.  I'm sure I can use the macro recorder to get step
> 2 of
> > my request.  That leaves me needing help with 1 and 3.  I can't imagine
> that
> > this involves very many lines of code?????

> > 1. Open read only without a prompt (assuming I can hold down shift to
> > get into it for edits when I need to).

> Dim MyDoc as Document
> Set MyDoc = Documents.Open(FileName:="C:\My Documents\My File.doc", _
>             ReadOnly:=True)

> (keep the MyDoc object variable because you'll need it for the next bit)

> > 3. Close the original document without prompting a save. (Focus will have
> to
> > return here after the merge?  Then focus again on the newly merged
> document?)

> MyDoc.Close SaveChanges:=wdDoNotSaveChanges

> > Any takers out there?

> Hope this helps!

> --
> Regards
> Jonathan West - Word MVP
> MultiLinker - Automated generation of hyperlinks in Word
> Conversion to PDF & HTML
> http://www.multilinker.com
> Word FAQs at http://www.multilinker.com/wordfaq
> Please post any follow-up in the newsgroup. I do not reply to Word questions
> by email