+ Reply to Thread
Results 1 to 3 of 3

Send attached spreadsheet with outlook or lotus notes

  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    42

    Send attached spreadsheet with outlook or lotus notes

    I need a macro that can attach a macro enabled Excel workbook to either Microsoft Outlook or Lotus Notes and send the email to the recipient. Once received, the recipient will add information to the workbook using other in-built macros, save it, and the return it to the originator. The originator and the recipient will not always be the same person.

    To keep things simple, I would like to use one "Send" button. I'd also like to have the user select which email system is being used at his or her end, i.e. Lotus Notes or Microsoft Outlook. I'd also like the user to be prompted to input the email address of the person to receive the email (with the attached Excel workbook) using an input box.

    So the macro must be able to:
    Prompt the user to select which email system is to be used (Outlook or Lotus Notes)
    Prompt the user to input the recipients email address
    Attach the macro enabled Excel spreadsheet to the email
    Send the email to the recipient

    The macro must be able to work at both the originator and recipient ends.

    Can anyone help?

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Send attached spreadsheet with outlook or lotus notes

    Macros for
    The Lotus Notes part : http://www.rondebruin.nl/win/s1/notes/notes.htm
    The Outlook part :http://www.rondebruin.nl/win/s1/outlook/mail.htm

    If you don't need Lotus Notes http://www.rondebruin.nl/win/addins/rdbmail.htm

  3. #3
    Registered User
    Join Date
    11-06-2013
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: Send attached spreadsheet with outlook or lotus notes

    Not exactly what I was looking for but I'll give it a go. Thanks

+ 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. Send Email - Outlook to Lotus Notes
    By davix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2013, 08:54 AM
  2. [SOLVED] Excel Macro lotus notes email clear attached sheet
    By johnny_w in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-02-2013, 08:24 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. Sending attached file using lotus notes
    By oakman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2007, 08:06 AM
  5. Send Mail - Code to test whether Lotus Notes / Outlook is used
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2005, 11:05 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