letter from database

[IOI]

having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it?

cheers

 

[aikea]

If you have Word or OutLook, you can use "Mail Merge" from tools menu.

 

[KeithG]

you could also use a report.

 

[IOI]

you could also use a report.

I did create letter report although it shows only first record no matter what I do...

 

[IOI]

If you have Word or OutLook, you can use "Mail Merge" from tools menu.

also I created mail merge in word with hyperlink to it in access form but...I get alert: this hyperlink might be harmful... everytime I click on it...how to get rid of it...security level is low at the moment

 

[aikea]

If you send your letter via email, security is not a problem. Your client will see the link. If he use outlook, he has to press ctrl key then click that link to open it.

You can send yourself an email, to test how it works.

Different email agent react differently to embeded links.