Hi, I tried the following: table [client] has field programemail(which has my email(jbalbo)) created a macro using sendobject opejectname is report RPTEMAILOPENCLIENT which has the field PROGRAMEMAIL
in recipient put [REPORTS]![RPTEMAILOPENCLIENT]![PROGRAMEMAIL] I get email message back mailer-daemon back with recipent as: [EMAIL PROTECTED] Thanks Joe --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Joe- > > As long as the email address is the Bound Column, you should be able to > simply reference the listbox. However, if the listbox is mult- select, > you'll have to write code to examine the ItemsSelected collection and build > the To list. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of eliotchs > Sent: Wednesday, January 04, 2006 11:25 AM > To: [email protected] > Subject: [ms_access] ?? on Using a form value or Listbox value for Recipent > on Email ?? > > Hi, > > I'm trying to use a value from a listbox(a hyperlinkfield on a table) > as a reciepent. > I set up a macro to use sendobject, but don't know how to set the > recipent as the listboxitem? > > Example, user chooses a name on a list, one of the fields is an > emailadress associated to that name, once the user presses the box to > send an email, I want the reciepents name to be that email field? > > Thanks in advance > Joe > > > > > > > > Yahoo! Groups Links > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
