Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Browse Open Actuarial Jobs

Life  Health  Casualty  Pension  Entry Level  All Jobs  Salaries


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12-03-2008, 09:39 AM
spencerhs5's Avatar
spencerhs5 spencerhs5 is offline
Member
 
Join Date: Jan 2007
Posts: 1,475
Default 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,
Reply With Quote
  #2  
Old 12-03-2008, 09:50 AM
GadgetGeek's Avatar
GadgetGeek GadgetGeek is offline
Note Contributor
SOA AAA
 
Join Date: Sep 2001
Location: I'm here, where are you?
Studying for a way to escape
College: Illinois College ('87)
Favorite beer: Stag
Posts: 11,154
Default

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.
Reply With Quote
  #3  
Old 12-03-2008, 10:34 AM
spencerhs5's Avatar
spencerhs5 spencerhs5 is offline
Member
 
Join Date: Jan 2007
Posts: 1,475
Default

Quote:
Originally Posted by GadgetGeek View Post
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.
Reply With Quote
  #4  
Old 12-03-2008, 10:54 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,238
Default !!!

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:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #5  
Old 12-03-2008, 11:17 AM
spencerhs5's Avatar
spencerhs5 spencerhs5 is offline
Member
 
Join Date: Jan 2007
Posts: 1,475
Default

Quote:
Originally Posted by JMO View Post
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.
Reply With Quote
  #6  
Old 12-03-2008, 01:17 PM
Old Timer's Avatar
Old Timer Old Timer is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: The Great East
Posts: 1,957
Default

Quote:
Originally Posted by spencerhs5 View Post
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.
__________________
Life is chaos personified.
Reply With Quote
  #7  
Old 12-11-2008, 08:08 PM
Gates Is Antichrist's Avatar
Gates Is Antichrist Gates Is Antichrist is offline
Member
SOA AAA
 
Join Date: Feb 2002
Location: Hell
Favorite beer: Pacifico
Posts: 156
Default

Quote:
Originally Posted by spencerhs5 View Post
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.
__________________
______
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
Reply With Quote
  #8  
Old 12-12-2008, 11:05 AM
spencerhs5's Avatar
spencerhs5 spencerhs5 is offline
Member
 
Join Date: Jan 2007
Posts: 1,475
Default

Quote:
Originally Posted by Gates Is Antichrist View Post
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.
Reply With Quote
  #9  
Old 12-12-2008, 12:05 PM
Gates Is Antichrist's Avatar
Gates Is Antichrist Gates Is Antichrist is offline
Member
SOA AAA
 
Join Date: Feb 2002
Location: Hell
Favorite beer: Pacifico
Posts: 156
Default

Quote:
Originally Posted by spencerhs5 View Post
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.
__________________
______
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.
Reply With Quote
  #10  
Old 12-12-2008, 03:09 PM
spencerhs5's Avatar
spencerhs5 spencerhs5 is offline
Member
 
Join Date: Jan 2007
Posts: 1,475
Default

lol
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 01:18 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.20177 seconds with 9 queries