Google
Search WWW Search My Site!
Email Code
Ivan F Moala
Can Do
Goto Guest book sign in page [Home]
Thanks for visiting my site lucky visitor:
This page was last updated on: April 16, 2007
Copyright © 2002. XcelFiles. All Rights Reserved Ivan F Moala
Tell a friend about this page
Here are some routines that involve your Emailer.

I started off with looking at coding for Outlook, but not everyone has/uses Outlook, so I expanded the page to include Outlook express (Please note that OE does not expose its' properties or method via COM), and of course Lotus Notes :-).

General:

Function to get a users default Emailer name eg. Lotus Notes, Outlook etc
See here for workbook





Microsoft Outlook

  • Setting a reference to Outlook
There are advantages to doing this rather then using html coding
to display a selection and this would be the preferred way
to emailing your data for display.
- From a Sheet Selection
- From Pictures in your Sheet

  • autosend onopen
  • bypass security (See Redemption code)
  • bypass security via mapi
  • check email
  • commands
  • contacts
  • create object
  • create task
  • email auto range
  • email02
  • GetSubFolders
  • make appointment
  • redemption email
  • redemption
  • send without save
  • sendmail_
  • Sites
  • OutLook_get data
  • OutLook_Get Number unread msgs
  • OutLook_GetNames
  • OutLook_Redemption
  • OutLook_RedemptionTest
  • OutLook_save attachments
  • OutLook_sendBCC
  • OutLookEmail_Using

  • LotusNotes send

  • LotusNotes Sendmail BCC CC

  • LotusNotes_dataBase

  • LotusNotes_Email

  • LotusNotes_Extract GetEmail

  • LotusNotes_Getdefault database

  • LotusNotes_GetEmail V4l

  • LotusNotes_sendemail

  • LotusNotes_Send XlRange (This is the one I am working on)
    (ie to send an Excel range as an Image)
OutLook Express:

Code to come
Lotus Notes:

Here are some useful routines for Lotus notes emailer.

I only use Lotus at work and since I rearly program at work I have not finished testing, programing and commenting the codes I do have. So I have incorporated here some routines that have been tested and used by my friends from around the world.

XlDennis and Juan Pablo G (MS Excel MVP), all reputable programmers.


I would also suggest you view posts made @ MrExcel search.
Search for NateO subject Lotus Notes. NateO has made some very useful code
available there, I highly recommend you view these posts.


When I have finished updating my codes I will post these to my site, until then please enjoy using the codes from my friends.