|
|
|
#1
12-03-2008, 09:39 AM
|
||||
|
||||
VBA and Lotus!!!
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, 
|
|
#2
12-03-2008, 09:50 AM
|
||||
|
||||
|
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.
__________________
Some people are like slinkies. Mostly useless, but provide amusement when pushed down the stairs.
|
|
#3
12-03-2008, 10:34 AM
|
||||
|
||||
|
Quote:
 i take it you didnt have many network files that you needed to send links for.
|
|
#4
12-03-2008, 10:54 AM
|
||||
|
||||
|
!!!
Off the subject, but why did you put all those exclamation marks in the thread title?
__________________
Carol Marler, "Just My Opinion" Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial. My latest favorite quotes, updated Apr 5, 2018. Spoiler:
|
|
#5
12-03-2008, 11:17 AM
|
||||
|
||||
|
Quote:
|
|
#6
12-03-2008, 01:17 PM
|
||||
|
||||
|
Quote:
__________________
Life is chaos personified.
|
|
#7
12-11-2008, 08:08 PM
|
||||
|
||||
|
Quote:
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.
__________________
______ ON STRIKE. Thomas Jefferson and I are on strike against AO over a little matter called the First Amendment and censorship against dissenting views. I hereby choose to toss my voluntary contributions into the Harbor rather than accede in slavery to the oppressor. Last edited by Gates Is Antichrist; 12-15-2008 at 10:41 AM.. Reason: too much L.D.S. in the Sixties
|
|
#8
12-12-2008, 11:05 AM
|
||||
|
||||
|
Quote:
On a more serious note, we will no longer have outlook on our system so using VBA (.send) is not viable.
|
|
#9
12-12-2008, 12:05 PM
|
||||
|
||||
|
Quote:
 Fair or not, AOL usage is a red flag for computer illiteracy. BTW I cringe when I use an AOLer's machine to browse.
__________________
______ ON STRIKE. Thomas Jefferson and I are on strike against AO over a little matter called the First Amendment and censorship against dissenting views. I hereby choose to toss my voluntary contributions into the Harbor rather than accede in slavery to the oppressor.
|
|
#10
12-12-2008, 03:09 PM
|
||||
|
||||
|
lol
|
 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
