Access 2003 multiple DoCmd.SendObject procedures on form.

[sunwindandsea]

I have form that many displays the e-mails of as a many as five different people on three different pages. Page 1 has the name of 1 person with their e-mail address. Pages 2 and 3 each have the names of 2 people, 2 different e-mail address. For the first two individuals clicking on the email address field displays usual Outlook untitled message screen with the email address in the Access field in the To window of the Untitled email. I’m using the standard

DoCmd.SendObject procedure

Page 1works fine
DoCmd.SendObject acSendNoObject, , acFormatHTML, streMail, , , , , True

Page 2 first email address works fine
DoCmd.SendObject acSendNoObject, , acFormatHTML, st2email, , , , , True

Page 2 second email address DOES NOT WORK
DoCmd.SendObject acSendNoObject, , acFormatHTML, st3eMail, , , , , True

I’ve tested the email addresses an page 3 and neither works using the
DoCmd.SendObject acSendNoObject, procedure

I’ve verified that the field names are correct, etc. I can’t resolve this issue. Don anyone have any ideas?

 

[danvlas]

Try Option Explicit at the top of the module.

You may have misspelled st3Email somewhere...

If it does not work, place a breakpoint and inspect the variable value at run-time.


HTH


Daniel Vlas
Systems Consultant

 

[sunwindandsea]

Thank it wasn't the spelling, it just started working yesterday as it should, the only change was I rebooted. ????? I have no clue.