+ Reply to Thread
Results 1 to 1 of 1

VBA to send email via Lotus Notes + attachment

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Kingdom of Frost
    MS-Off Ver
    2007
    Posts
    6

    VBA to send email via Lotus Notes + attachment

    Hello,

    Any idea if I can send a Lotus Notes email WITH attachment via Excel VBA code?

    I know that I can send a normal mail via Lotus Notes, but absolutely no idea if it can be done with an attachment.

    The process with the current macro:

    1. The macro creates a new worksheet.
    2. The macro copypastes information from the main worksheet into the new blank one.
    3. The macro creates a new workbook out of that newly created worksheet and deletes the newly created worksheet from the mother file.
    4. The macro saves the new workbook.

    I would like the macro to send the file as attachment automatically to specific email address in point 4.


    Help much appreciated since I'm on a thin ice here with the code..

  2. #2
    Registered User
    Join Date
    01-24-2013
    Location
    Kingdom of Frost
    MS-Off Ver
    2007
    Posts
    6

    Re: VBA to send email via Lotus Notes + attachment

    Hello all,

    I found after all an old post on this, which works now in the way I want it to work except for one tiny part. Now the subject of the message is static, I would like it to add value from Cell A1 at the end of the subject line. IE, "Here's the report for sales from + A1". But merely adding & "A1" at the end of the subject line didn't work.. Any ideas?

    Please Login or Register  to view this content.
    Last edited by koodicoderi; 08-30-2013 at 04:04 AM.

+ 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. VBA Code: MACRO to send lotus notes email with excel attachment
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 10:23 AM
  2. Build and send Lotus Notes email with WS as attachment
    By Phiabell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2012, 09:36 AM
  3. Send an attachment through Lotus Notes
    By just_some_guy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2010, 12:37 PM
  4. Send Excel attachment via Lotus Notes
    By simon.q.rice@gsk.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2006, 10:25 AM

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