Using ListBox value as "Body of outlook task"

[AccessFreak]

Using ListBox value as "Body of outlook task"


Hi there

I have inserted an "add outlook reminder" button to my database, this is working perfectly. Now, i would like the "body" of the outlook task to get its data from a list box on my reminders form

it is currently getting the "body" from a text box on the reminders form, which works fine, but instead of the user entering the body, I would like the body to populate from a listbox (not a selected item in the list box, just every record in the listbox)

is this possible?

[pbaldy]

Sure; you would have to loop the listbox selections, like:

For i = 0 To Me.ListboxName.ListCount - 1

[AccessFreak]

Thank you for your reply. Where would this code go? In the .Body section of the Outlook Task Code?

[pbaldy]

Well, you didn't post any code but I would use it to build a string that was eventually used for the body.