M
msalesb
Hi, I work in a library and I exported from our library management
system a file with our patrons contacts, the items titles that they
checked out and that they should have already checked in and then
imported it to an access database. I have the patrons data on a form
and the items they checked out on a subform inside that form. I created
another form from which I plan to send e-mails warning the patrons that
they are delayed with the items check in. The form from which I am
going to send the e-mail is called "send_mail". I would like to put
there an introduction text like: "Dear sir, you are delayed with some
items check in..." and then put the items titles. My idea is to have
a button on the patrons form and when I click it the "send_mail"
form opens and the introduction text appears followed by the items
titles. I put the following code on it:
DoCmd.OpenForm "send-mail", acNormal, , , acFormAdd
Forms![send_mail]!.Value = Me![email].Value
'The code that I am using to put the introduction text and the titles
is:
Forms![send-mail]![text].Value = " Dear sir, you are delayed with some
items check in..." & Me![title].Value
'but of course that I am only getting the first title! Can anyone
help on telling me how may I put the subsequent titles? Thanks in
advance.
Best regards,
Miguel
system a file with our patrons contacts, the items titles that they
checked out and that they should have already checked in and then
imported it to an access database. I have the patrons data on a form
and the items they checked out on a subform inside that form. I created
another form from which I plan to send e-mails warning the patrons that
they are delayed with the items check in. The form from which I am
going to send the e-mail is called "send_mail". I would like to put
there an introduction text like: "Dear sir, you are delayed with some
items check in..." and then put the items titles. My idea is to have
a button on the patrons form and when I click it the "send_mail"
form opens and the introduction text appears followed by the items
titles. I put the following code on it:
DoCmd.OpenForm "send-mail", acNormal, , , acFormAdd
Forms![send_mail]!.Value = Me![email].Value
'The code that I am using to put the introduction text and the titles
is:
Forms![send-mail]![text].Value = " Dear sir, you are delayed with some
items check in..." & Me![title].Value
'but of course that I am only getting the first title! Can anyone
help on telling me how may I put the subsequent titles? Thanks in
advance.
Best regards,
Miguel