Re: sending data to multiple people

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

OK, I have a sample of exactly what you are asking at:

http://www.datastrat.com/Download/EmailSenate2K.zip

Please do not actually send the emails to the senators.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jean-Paul" <jp.dewinter@xxxxxxxxxx> wrote in message
news:sSEDk.3972$a24.3375@xxxxxxxxxxxxxxxx
OK... this I understand but,

When I click a name in a listbox it should appear in the entryfield which
I fianlly will use in the sendObject command.

exapmle:
I have a listbox with Arvin, John, Mary, Daisy

I click John,
John is put in the field
automatically a ; is placed behind the name
then I click Daisy
Daisy appears in the field

So fianlly I get
John@whatever; Daisy@whatever

What command do I need in the listbox
How to get it in the field
What for the last name because, normally I would have something like
John@whatever; Daisy@whatever;
Where the last ; is too much

Thanks

Arvin Meyer [MVP] wrote:
The first column of a listbox can be referred to like:

Me.Personeelslijst.Column(0)

The second column would be:

Me.Personeelslijst.Column(1)

and so on. SendObject recognizes the email address only in the To field,
but you can put the person's name in the body of the message.

A semi-colon ; is used to separate email addresses.


.

Relevant Pages

  • Re: sending data to multiple people
    ... When I click a name in a listbox it should appear in the entryfield which I fianlly will use in the sendObject command. ... I have a listbox with Arvin, John, Mary, Daisy ... I click John, ... SendObject recognizes the email address only in the To field, but you can put the person's name in the body of the message. ...
    (microsoft.public.access.formscoding)
  • Re: Yes/No Display
    ... Thank you John. ... You can use the format function in the query that is the source for the list box. ... After you modify the source you should then see Yes or No in the listbox for ... "Golfinray" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: datarowview
    ... Thanks John. ... I had tried selectedvalue before as well. ... I even have a textbox that displays the selected item from the listbox and tried substituting it in the query. ... > SQL that's referencing the selected item in the listbox. ...
    (microsoft.public.dotnet.framework)
  • Set selection item for listbox
    ... I want to search a listbox for a term and set the selection to that term: ... set foo "John" ... set listitem [list John Paul George Ringo] ...
    (comp.lang.tcl)
  • Re: Yes/No Display
    ... John and Golfinray, ... You can use the format function in the query that is the source for the list box. ... After you modify the source you should then see Yes or No in the listbox for ...
    (microsoft.public.access.gettingstarted)