RE: help with form command

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

Thank you so much for the quick response.

I had no problem understanding the list box instructions, but could you
please provide the step-by-step detail for the remainder of your instructions
for the command button? I'm sorry for my ignorance - I tried to figure it
out, but I just couldn't!!

Thanks again!!

"Klatuu" wrote:

What you need is a multi select list box with a list of all the email
addresses. You probably want a two column query for your list box that has
the person's name to make it easy for the user to select. Make the email
address the firsl column and the name the second column. You can hide the
email address from the user by setting the column widths property of the list
box to something like 0";3"
The 0" will make the email address hidden. The 3" you can adjust to show
the name properly. Then in the click event of the button where you send the
email addresses you will want to create a string to use in the To argument of
your SendObject. Here is how you would do that:

Dim strTo As String

With Me.MyList Box
For Each varItem In .ItemsSelected
strTo = strTo & .ItemData(varItem) & "; "
Next varItem
End With

At this point, strTo will be a string of the email addresses separated with
a ;
--
Dave Hargis, Microsoft Access MVP


"rejoyce40" wrote:

I've learned a lot through this help forum, but only enough to be dangerous!

I would like to have a form displaying names that I can select [multiple
select] and then have a command button that would open the email program with
the email addresses of the selected names in the To: line. I can then write
the message in the body of the email.

I don't need to attach anything, via the form, to the email - just want to
be able to select multiple email recipients.

I've tried modifying the Email2Senate form, but my limited knowledge didn't
get me anywhere but frustrated.

Your help would be much appreciated, and thanks in advance!
.

Relevant Pages

  • RE: help with form command
    ... Do I use the Command Button Wizard or do I use the properties/On Click for ... I had no problem understanding the list box instructions, ... Dim strTo As String ...
    (microsoft.public.access.forms)
  • RE: help with form command
    ... You would want to use the Click event of a command button to send the email. ... Do I use the Command Button Wizard or do I use the properties/On Click for ... I had no problem understanding the list box instructions, ... Dim strTo As String ...
    (microsoft.public.access.forms)
  • Re: Execute a string
    ... I saw that but there are not enough instructions for me on how to implement. ... >> for processing a string of code built on the fly. ...
    (microsoft.public.dotnet.languages.csharp)
  • TIP #185: Null Handling
    ... nulls, and command modifications for manipulating them. ... Tcl deals with strings, the universal medium for representing data. ... is know and it is an empty string, but if a respondent forgets to give ...
    (comp.lang.tcl)
  • Re: Determine how Word was launched
    ... inspect the command line used to launch Word. ... Private Declare Function GetCommandLineA Lib "kernel32" As Long ... Public Function GetCommandLineAs String ... Dim lngCmdLinePtr As Long ...
    (microsoft.public.office.developer.vba)