create letter from record

[woja]

Hi everyone

I have a membership database that works well with [firstname],
[lastname], [address1], [address2], [city] fields.

I would like to put a button on the form to create a letter in Word
which pastes in the recipient's name and address, for just the current
record.

It would be fine for that to just be at the top of a new document, but
ultimately I'd like that to paste into a template with mailmerge fields
in it.

Can anyone get me started on this? I have some elementary VBA knowledge.

Thank you very much.

Regards
Roger

 

[sam]

You will just need to set up a query that shows the
current record. The criteria for the query will be the
index number of the record you are viewing
I normally run a query to write the records I want in the
mailmerge to a table. Delete the old and append the new.
Then I link word to the table. It can probably be done
linking directly to the query but that's how I like to do
it.

Hope this helps