+ Reply to Thread
Results 1 to 10 of 10

Change Excel VBA To Include Input Box For Emailing using Lotus Notes

  1. #1
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    Change Excel VBA To Include Input Box For Emailing using Lotus Notes

    I currently use the following code - with no problems at all, and it emails to the recipients listed ok. But i would like a pop up box with a selection of managers - which allow the user to select just one, so that the manager gets a copy too.

    Is this at all possible......

    Please Login or Register  to view this content.
    Regards JonesZoid
    Last edited by JonesZoid; 03-04-2010 at 09:33 AM.

  2. #2
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    Re: Emailing In Lotus Notes

    Just Bumping

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Emailing In Lotus Notes

    is this being run in lotus notes?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    Re: Emailing In Lotus Notes

    No - it is a button in excel, that attachs the workbook into a Lotus Notes email. As i explained it emails in the code to the correct people, but i need the engineers to be able to select their manager - so they get a copy too.

  5. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Emailing In Lotus Notes

    ok no prob. ask a mod to move this to the programming sub forum. you'll get more response

  6. #6
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    Re: Emailing In Lotus Notes

    How do i do that...

  7. #7
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Emailing In Lotus Notes

    go to the main page,
    http://www.excelforum.com/index.php
    scroll down to bottom
    in" whats going on" "currently active users" look for a name in green font then pm with your thread url and ask them to move it.
    errr my mistake its already in there!
    but i'd advise you to change title to something like
    "change excel vba to include input box for emailing using lotus notes"
    or some such
    Last edited by martindwilson; 03-03-2010 at 08:34 PM.

  8. #8
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    Re: Emailing In Lotus Notes

    Just Bumping - For a glint of hope.....

  9. #9
    Forum Contributor
    Join Date
    05-20-2008
    Posts
    162

    Re: Emailing In Lotus Notes

    Has anyone got any ideas please.....

    JonesZoid

  10. #10
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Change Excel VBA To Include Input Box For Emailing using Lotus Notes

    hi JonesZoid,

    Maybe the attached example will help...
    I've used named ranges on the Ref Table sheet to create a list of possible email recipients & have then put them into a userform for the user to choose from.
    Note, I may have included some un-necessary code (I copy & pasted from previous files) & it could probably do with some more appropriate error checking but hopefully it will provide a glimmer of hope ;-)

    btw, I don't have Lotus Notes so I haven't tested the final product.

    hth
    Rob
    Attached Files Attached Files
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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