Passing parameters from Access to Word

[Paul Cooper]

I have two Access tables

They has (for this description) two fields, Name and Notes.
Name is a 25 long character field
Notes is an integer which links to the auto counter for
the second table

The second table contains two fields
Auto counter: An integer number and
FreeText: A Memo field

Table one has the following data

Paul 1
Sue 1
Fred 2

Table two has the following data

1 For this problem please contact [vName]
2 This currently has [vName] assigned to it

I would like a report, ideally in Word that replaces the
[vName] with meaningful data i.e.

Report 1: For this problem please contact Paul
Report 2: For this problem please contact Sue
Report 3: This currently has Fred assigned to it

The memo data in table two must not be corrupted as the
real database has 400 names (table 1) and 39 statements
(table 2) where up to 8 (so far) table 2 statements can be
linked to a single name.

i.e. "For this problem please contact Sue. This currently
has Sue assigned to it" is a viable output.

I either need to copy the memo to a scratch area and
modify it before generating the report or need to pass the
name to Word and global replace [vName] with table 1.Name.

Any ideas?

Paul