Problem creating an email using the oCmd.SendObject command

[mjwillyone]

Friends,

In the past I have successfully created buttons on forms that allow me to e-mail particular field values to individuals. This is a great way of asking individuals to help us keep our records current. I have not had any problems with small e-mails.



I am working now, however, on a VB scripted button that will place the value of 15 or so fields in one e-mail. I created the script but I am wondering if there is a limit to the number of characters I can use with the oCmd.SendObject command. Here is the error I receive:

"Compile Error: Method or data member not found" and it highlights the following text: & Me.Check533

The above field name is correct so I don't know what the problem may be.

I have attached a full copy of the VB script.

Thanks,
Mike

[RuralGuy]

Do you plan to replace the "& Email Address &" with the actual email addy?

[mjwillyone]

I hadn't at this point ... is that the problem?

Do you plan to replace the "& Email Address &" with the actual email addy?

[RuralGuy]

I doubt it but I just had to ask. I could not find the limit on the argument but I'm sure it has one. The only way I know of to troubleshoot this issue is to start small and keep building up the string until it breaks again. I like CDO and here's my favorite email site: http://www.granite.ab.ca/access/email.htm