need help with email code

[wilkob]

I have a database from which users e-mail country specific reports to a group of receipients.

I am currently using the following code:
DoCmd.SendObject acReport, "Report UK", "SnapshotFormat (*.snp)", "rec1@company.co.uk;rec2@company.co.uk;rec3@company.co.uk", "", "", "Report UK", "See attached document", False, ""

Everytime when a receipient needs to be changed or added the users ask me and I have to change this code; this is offcourse not the best way.
What I would like to do is set up a table showing for each country the e-mailreceipients, link this to my form and use the field from the form in my code which is activated by a click on a button

As I am relatively new when it comes to access and VBA I would really appreciate some help

 

[wilkob]

Thank you for your quick reply. I in the menatime kept breaking my head over this email thing. I found two other examples from which I took some code and sort off got something working.
The problem that I have in attached database that even though there are e-mailaddresses in the field on the form the code considers the field empty (null) only after clicking on the field the script works.

My idea however was to make the field a hidden field
Any idea how I can overcome my problem