Linking to MS Word

[Not Me]

Hi,

What's the simplest way to link database records to a word document? The
requirements are very simple, we need a way of creating one-off letters with
address/contact information filled in.

I could do a mail-merge but isn't that really for batches of letters? How
about a report that automatically opens from within word for editing?

I appreciate any ideas you may have!

Cheers,
Chris

[Tom van Stiphout]

On Wed, 19 May 2004 11:31:02 +0100, "Not Me"
<No****@faker.fake.fa.kee> wrote:

A batch can have a size of 1. It's still the preferred way.

If you REALLY want to do things the hard way, you can use Automation
from Access to open a Word doc, find certain placeholders, and replace
them with your data. Just like Word's own MailMerge would do.

-Tom.

Hi,

What's the simplest way to link database records to a word document? The
requirements are very simple, we need a way of creating one-off letters with
address/contact information filled in.

I could do a mail-merge but isn't that really for batches of letters? How
about a report that automatically opens from within word for editing?

I appreciate any ideas you may have!

Cheers,
Chris

[Not Me]

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:2k********************************@4ax.com...

On Wed, 19 May 2004 11:31:02 +0100, "Not Me"
<No****@faker.fake.fa.kee> wrote:

What's the simplest way to link database records to a word document? The
requirements are very simple, we need a way of creating one-off letters withaddress/contact information filled in.

If you REALLY want to do things the hard way, you can use Automation
from Access to open a Word doc, find certain placeholders, and replace
them with your data. Just like Word's own MailMerge would do.

That's exactly what I've just done - of course using somebody else's code
:oP
Works from the database to word, rather than the other way round so seems
easier for the end user.

Cheers,
Chris

[Albert D. Kallal]

The most best and easy way?

Sure....just grab my super easy word merge!

You can find it here:
http://www.attcanada.net/~kallal.msn.../msaccess.html

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.attcanada.net/~kallal.msn