Need Some Help, Please,.................. 1

[jdwm2310]

Hi,

I have a form and I want to create command button that will take the selected record and send it to the person via email. Is this possible, if so please advice as how to approach this.

Thanks

 

[jebry]

Hi!

Go to the Access help and check out the SendObject method. Off the top of my head I don't remember all of the ins and outs of the method, but you should be able to find it in help. If memory serves, there is a problem with sending forms in that SendObject wants to send all of the data in the recordsource. To get around this, you can apply a filter to the form prior to sending it or you can set up a report based on a query that will select only the current record and then send that report.

hth
Jeff Bridgham

 

[jdwm2310]

Thanks Jeff!!s-)

 

[jdwm2310]

Jeff,

I inserted this code: DoCmd.SendObject,acSendForm,"Employees", acFormatRTF,"Email Address",,,

But it's not working, I want each person their own record enabling them to view only their record. I also have a field name with their email address. What I want to do is select the person's name and then click on the send button. The send button will then send the record of that person based on the email that was provided.

Can you please help....Thanks

 

[jebry]

Hi!

A few of questions, where does "Email Address" come from? Do you get any sort of error message? Is this code exactly what you typed in?

Jeff Bridgham

 

[jdwm2310]

Email Address is coming from the Employee form. Yes that was the exact coding. Any help would be appreciated.

 

[jebry]

Hi!

I am going to assume that Email Address is a field or a text box. Try this:

DoCmd.SendObject,acSendForm,"Employees", acFormatRTF, Me![Email Address]

Let me know how that works

hth
Jeff Bridgham

 

[jdwm2310]

Jeff,

but how can I specified a specific report on this code.
I want to select someone from a list box and when I select that person's name and then click on the send button I want that person to receive his/her record.

I inserted the code and I got a Command or Action 'SendObject' isn't available now.

 

[jdwm2310]

Jerby,

I get a Run-error 2046, stating that the SendObject is not available now...I am using Access 97 can that be a problem??

 

[jebry]

Hi!

Sorry I missed your previous post. I think you will need to base your report on a query and in the criteria of the name field in the query type:

=[Forms]![YourFormsName]![YourListBoxName]

That should pull up the report and limit it to the users record only.

hth Jeff Bridgham
bridgham@purdue.edu

 

[jdwm2310]

Jeff,

I instead created a filter, and that's working for now, but my main concern is emailing the individuals. I used your coding but I am getting a run time error 2046: The command/action 'SendObject'is not available now. FYI I am using Lotus Notes R5 could this be a problem?

 

[quest4]

I am assuming you are using Access, but which version? Next when you installed Access, did you use TYPICAL or default? If so there is your answer, Acess normally does not install everything you need, always install Office products with the full or Complete installs, so you get everything, it usually takes up more space, but you will stop geting the not available messages. Hope this

 

[jdwm2310]

Access is 97 and the Support Group installed Access using Custom, what should I do???

 

[jdwm2310]

I definitely need some help with this? Can't anyone help me create a button that will send the record via email. I am using Lotus R5. When they installed Access 97 they used Customize. Any suggestions as to what I should do???

I tried inserted the code:
DoCmd.SendObject,acSendForm,"Employees", acFormatRTF,"Email Address",,,

But I get a sign stating that the SendOjbect is not available...Please help

 

[jebry]

Hi!

Sorry I missed your posts. I was away from computers for a few days because I was going college searching with my son.

Here is what Access help says(cut and paste)

The SendObject action is available only if you have a MAPI-compliant electronic mail application installed on your computer, or if you have a VIM-compliant electronic mail application and have installed and set up Mapivi32.dll. For information on how to install and set up Microsoft Access support for VIM mail applications, see the Microsoft Office 2000/Visual Basic Programmer's Guide.

To get the Programmer's Guide:
How to obtain the Microsoft Office 2000 Resource Kit
Note Some of the hyperlinks in this topic go to the Web. You can switch back to Help at any time.

The Microsoft Office 2000 Resource Kit is the definitive guide to installing, configuring, and supporting Microsoft Office in your organization. Designed for system administrators, consultants, and power users, this guide offers complete coverage whether you're running Microsoft Office on Windows 95, Windows NT Workstation, or the Macintosh.

You can obtain the Office Resource Kit wherever computer books are sold or directly from Microsoft Press.


Microsoft Press books are available worldwide wherever quality books are sold. To order the Office Resource Kit (ISBN: 0-7356-0555-6) directly, call (800) MSPRESS in the United States or (800) 667-1115 in Canada. For more information, visit the Microsoft Press Web site.


You can also download the Office Resource Kit from Microsoft on the World Wide Web.

I am sorry to say that I am not familiar with Lotus R5 so I do not know if it is MAPI compliant or VIM compliant. Sorry that I don't know more. If you figure something out, let me know.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[jdwm2310]

Thanks for all the outstanding information, I wish your son lots of luck B-)