VBA and Lotus!!!

[spencerhs5]

So my company made the switch from Outlook to Lotus (its okay, you can start feeling sorry for me)... Anyways as you may know inserting a link into lotus is awful. Therefore I decided I was going to create a program in excel to send an email using the lotus domino library. I have found code to send an email and include an attachment, but trying to figure out how to add a link a.k.a. hotspot is next to impossible, if anyone has experience with lotus and vba let me know and I will post what I have so far.

Thanks,

[GadgetGeek]

No help, but I envy you. Having come from a Lotus environment to an Outlook one, I really miss Notes. My most missed feature, being able to remove the attachement before filing the email.

[spencerhs5]

Originally Posted by GadgetGeek

No help, but I envy you. Having come from a Lotus environment to an Outlook one, I really miss Notes. My most missed feature, being able to remove the attachement before filing the email.

ha ha, think our companies would agree to let us switch user licenses?!?!

i take it you didnt have many network files that you needed to send links for.

[JMO]

Off the subject, but why did you put all those exclamation marks in the thread title?

[spencerhs5]

Originally Posted by JMO

Off the subject, but why did you put all those exclamation marks in the thread title?

Probably because I am angry and its an expression of anger... and that is off the topic.

[Old Timer]

Originally Posted by spencerhs5

Probably because I am angry and its an expression of anger... and that is off the topic.

We switched to Outlook and now I can't reply and have the attachment included. I need to forward the e-mail. I could do that with Notes.

[Gates Is Antichrist]

Originally Posted by spencerhs5

So my company made the switch from Outlook to Lotus (its okay, you can start feeling sorry for me)... Anyways as you may know inserting a link into lotus is awful. Therefore I decided I was going to create a program in excel to send an email

Since going off topic has been decherrified on this post, with regrets to OP who is leaving Outlook, does everyone know how simple it is to send an Outlook email from VBA? I mean, after starting a real long job, you go home after it starts to eat Bon Bons and watch The Matrix while you listen for the "You've Got Mail" from the next room? One way is to go
if iRemaining = 100 then
MySend("Down to last " & iRemaining)

or get an email once every 1000 loops, the absence of which may alert you to a bombing:
if 0=iRemaining mod 1000 then MySend(iRemaining & " done at " & Time) 'use Format()

One short and sweet example is http://dbageek.blogspot.com/2004/09/...g-outlook.html One thing it might have mentioned is to go (in VBA) tools menu, reference, and check Microsoft Office 11.0 Object Library (or whatever Office version you are on). Then .Body is the message text that's mailed.

Thought you needed server access from home in order to check a job? I confess that I did, until seeing how very simple .Send is.

spencer: if all else fails, think about sendkeys. Trinity would call it the ugliest hack of her life, but it's one fallback.
*****************************
Edit 12/15/08 10:40 AM EST:
Hmm, did anyone bother to try this. The "tools/reference" item above should have been

Microsoft Outlook xx.0 Object Library

The second word is Outlook rather than Office. Sorry.

[spencerhs5]

Originally Posted by Gates Is Antichrist

I mean, after starting a real long job, you go home after it starts to eat Bon Bons and watch "24," while you listen for the "You've Got Mail" from the next room?

If you are still using AOL i'm not to sure I want to listen to anything you have to say!

On a more serious note, we will no longer have outlook on our system so using VBA (.send) is not viable.

[Gates Is Antichrist]

Originally Posted by spencerhs5

If you are still using AOL i'm not to sure I want to listen to anything you have to say!

Fair or not, AOL usage is a red flag for computer illiteracy. BTW I cringe when I use an AOLer's machine to browse.

[spencerhs5]

lol