Joe- SendObect won't open the report, so your reference to [REPORTS]![RPTEMAILOPENCLIENT]![PROGRAMEMAIL] should either return an error or nothing. I think you must also put an equals sign in front of the expression to force the macro to evaluate it. You must reference an open object to pick up the email address. If it is stored in a table, you could try using DLookup.
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 1:14 PM To: [email protected] Subject: [ms_access] Re: ?? on Using a form value or Listbox value for Recipent on Email ?? 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 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/
