Sende aktuel post til e-mail

change the query so that it has a criteria which uses the form/field to filter the query result

The query should have a field which is also on the form. On the criteria for this field you need to reference the field on the form, something like

forms!YourForm!YourField

Du kan bruge den samme forespørgsel ved at referere til et felt i din formular. I det følgende sætter du variablen VARa = feltet email i din formular og benytter variablen i koden:

Dim VARa as String
VARa = Me.email
DoCmd.SendObject "", "HTML(*.html)", a, "", "", "Hej", "e-mail fra acces", False, ""

hows it going jedi_dk?

Hej

Jeg tror ikke min accessviden er stor nok til at kunne bruge jeres forslag. Jeg havde håbet mere på en løsning, som IKKE skulle gøre brug af direkte programmering. Så i princippet tror jeg at jeres svar er rigtige, men jeg er ikke så god til access til at kunne bruge det.

John

if you send me your dB I will put something together for you

eksperten@NOSPAMsanthell.dk

remove NOSPAM

status?

jedi_dk do you still need help here?

Hej.

No. At the moment I try another way. But thanks for your help.

John

OK! If you close the question then others wont use time on it

How do I close it?

you need to accept on eof the answers. If you place an answer yourself then you can accpet it and keep the points! Or you can accept those given already

mange tak :o)