Access 2010 - Email - Trying to insert a Hyperlink into the VBA of an Onclick Email

[Parker]

Ok!

I got something an error


Run-time error '-2147417851 (80010105)':

Automation error


The server threw an exception

[Parker]

Under debug:

it highlights this line

Set MailDoc = Maildb.CREATEDOCUMENT

[Parker]

If I include Sub SendMail() in the begining of the code I recieve a "Compile error: Expected End Sub" and it highlights the first line of code in the debugger Private Sub Save_Record_Click()

[June7]

I said not to include that line.

If sending email works with early binding, should work with late binding. All I can say is both work for me using Outlook. I don't have LotusNotes so cannot test. Can only offer you references. Code shown for LotusNotes is different from that for Outlook.

[ItsMe]

Is this thread the same topic as the other one??

https://www.accessforums.net/program...ens-43311.html

[Parker]

I know you said not to include... I tried it both ways since both suggestions did not work.

[June7]

Basically. The other evolved into discussing CDO code.

Sorry, can't help with debugging code for LotusNotes.

[ItsMe]

The example I provided in the other thread can be incorporated into the Lotus Notes VBA. There is a Lotus Notes VBA example that allows for HTML body.