Getting value from text box question

[Spyder757]

I currently have the following code:

DoCmd.SendObject acReport, "Report", "SnapshotFormat(*.snp)", "[Forms]![Menu]!", "", "", "Call Outs", "", False, ""

My problem is that instead of checking the email text box found on the menu form it simply puts the "[forms]![menu]![email]" as the address in outlook.

Any ideas how I could get it to take the value of the text box (which is an actual e-mail address) instead? I'm a VB n00b.

 

[Spyder757]

Nevermind I posted prematurely, I figured out how to handle this. All I had to do was remove the " " from around my form ref.

I guess my next question would be is there any thing I could add to my code so Outlook wouldn't prompt the user every time about a peice of mail being send on their behalf?

 

[bonifale]

Just guessing; but have you tried

Application.Interactive = False

Application.Interactive = True