Starting a Mail Merge from Within Microsoft Access - 1 record only

[Maillme]

Hi there,

Im creating a database that im going to use to create contracts for a speciic record.

my contract is a 3 page word document and when i try and put the text into a report it informs me my text is too big.

So, now im thinking, i need a button within my access form, that when pressed will open word, and fill in the required fields from the record in which i pressed the button from.

Are there any resources on how to do this available that someone can point me in the direction of - or help me out?

many thanks,
neil

 

[kjv1611]

I'd say you need to do some VBA programming for this. You can control both Word and Access with it.

Basically, you'll want to run code (at the least) to open a new MS Word Doc or either open a template, and then start sending text in bits to it from your database.

There would be different ways to do that, but I'm not 100% sure what would be the best. One possibly easy way, I guess, would be to use the clipboard, and basically just send a small portion at a time to the clipboard, then paste from there into Word.

Either way, you'll probably need to familiarize yourself with the Word object, probably the DOA Recordset object, and I'm sure a few others.

If you want to proceed via VBA, then you'll need to post at least this question, or else a series of follow-up questions over at the VBA forum, perhaps more specifically the Access VBA forum:

General VBA:
forum707

MS Access VBA:
forum705

Perhaps someone else can get you pointed a little better. But at least that might give you some leads to take to the help files, Google, etc.

--

"If to err is human, then I must be some kind of human!" -Me