Email Reports 1

[dvannoy]

I posted this subject awhile back but got no response...

Just wondering if there is a way to use the email function in access using Lotus Notes?...I know it can be done using outlook...darn microsoft

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[JoeMiller]

See these two faqs DougP wrote:

How to use the "SendObject" Method to send E-mail


VBA code E-Mail method (better than SendObject)


HTH
Joe Miller
joe.miller@flotech.net

 

[dvannoy]

Works great...I am having some trouble inserting the users name in the To: section of the email..

I got it to open up Lotus Notes and not default to outlook but still having some problems with the subject, bcc, cc and to fields...

maybe i'll figure it out DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[JoeMiller]

If you have trouble let me know, I implemented his 2nd solution in a database for testing purposes and do remember having some trouble with it myself. I can email you the db if needed.
Joe Miller
joe.miller@flotech.net

 

[dvannoy]

That would be great...still getting all kinds of errors...the funny thing is if i create a hyperrlink then click on it...it works great...but then i cant make it fill in the subject etc...I would appreciate it if you could send me the db....

dvannoy@onyxes.com
DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[sera]

Hey Joe, I am trying to do this also... Can you send me a copy of the database also?
whitse@inel.gov
Thank You,
Sera

 

[sera]

Dvannoy, Did you ever get this to work? I know how to do it and it is not the same as Joe's method. If you need me to post the solution I will.
Sera

 

[ekim]

I have this exact problem and would appreciate being included in the routing of the two methods from Sera and Joe. I've retrieved the FAQ's. Thanks for any assistance on this.

 

[dvannoy]

The sample Joe sent me works great!.. I added some code to the form based on what i'm doing. The only problem is that I cannot get the CC or BCC function to work in Lotus Notes...It is a Lotus Notes problem for sure. Joes example works 100% fine with outlook.

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[ekim]

Would you mind forwarding me what Joe sent you. Did Sera send another method as well. I'll e-mail you directly as well. Thanks

 

[sera]

ekim! I will send you what I have. It is pretty lengthy, but I will send it to you. Just e-mail me at whitse@inel.gov.
Sera

 

[pat2469]

I am running into this same problem could send me the information also. I would greatly appreciate it.

Thanks,
Pat

 

[sera]

If you would give me your e-mail address or e-mail me at the address above I will send you the code that I have. I haven't done this in a while. I will be able to send it to you Friday night.
Sera

 

[dougcoulter]

Sera...

Do you still have the code for this application? I am starting a project that will require Access report e-mailing using Lotus Notes. I would really appreciate any help !

Thanks...

...Doug (dcoulter@datability.biz)