+ Reply to Thread
Results 1 to 3 of 3

How to use Function listed in this webpage to send email

  1. #1
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    How to use Function listed in this webpage to send email

    Hi Experts,

    Need some help here .

    I was looking for code to send Emails from Lotus Notes WITH SIGNATURE and came across this post.
    http://www-10.lotus.com/ldd/nd85foru...3?OpenDocument

    Seems the author has created function . I am not much familiar of functions.

    So far I have copied this code in my excel developer window in a seperate module however I am not sure how to invoke /use this code. Can someone give me a practical example using this code on the steps need to be performed to send email .

    Thanks in advance.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: How to use Function listed in this webpage to send email

    Hello Ravisca2003,

    The function f_SendNotesEmail can be used like a formula on the worksheet. You must first save the macro code into a VBA MOdule in your workbookl before you can use it.

    To use this in cell, place an equal sign before it and provide data for all of the arguments. If it successfully sends the email then a TRUE will appear in the cell. If not , you will see a FALSE.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: How to use Function listed in this webpage to send email

    Hi Leith,

    Thanks for your time to look into my issues.

    I tried this option however when I , lets say in CELL A1, place "=f_SendNotesEmail", it does not automatically pop up the function like what happens when we use inbuilt functions of Excel like Sum .

    Also if you see the function, the definition is in below format
    f_SendNotesEmail(strTo As String, strCC As String, strBcc As String, _
    strObject As String, strBody As String, strAttachment As String, blnSaveIt As Boolean)
    Also I am using it like this

    =f_SendNotesEmail([email protected],,,"Hello","This is a sample body text",,,)

    Please let me know if this is the correct way to use this function or else

    Again your time spend to help me is much appreciated !!

    Thanks

    Ravi

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 03-06-2018, 11:38 AM
  2. Replies: 5
    Last Post: 03-06-2018, 11:38 AM
  3. Need a if function to send email if rate is not met
    By Derekwit in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2016, 03:57 PM
  4. Workflow with signatures (if cell=x then send email, if signed then send email)
    By Kate2811 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2014, 05:37 AM
  5. Send New Email W/ Body of Received Email, Then Delete Sent Email
    By edneal2 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 07-01-2013, 12:45 AM
  6. Code to send attachments to mail id s listed on excel sheet
    By chaitanya051 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2010, 04:20 AM
  7. Send from excel to webpage...is it poss?
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1