Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Lotus Notes and MS-Excel (97 SR2i)

    Hello All

    I have written a VBA routine that e-mails using Lotus Notes. It works OK but I can't have multiple recipants in the To: CC:, or BCC fields.

    Anyone knows why? Any one knows a Lotus Notes developer who knows VBA?

    Any one who would like to see the code I will send you a clean copy if you send me your e-mail, or maybe some one can tell me how to send a workbook to the list.

    Thanks

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Lotus Notes and MS-Excel (97 SR2i)

    I'd be interested. Can you post your code here in the lounge?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Lotus Notes and MS-Excel (97 SR2i)

    Catharine

    I would clean it up and post it over the weekend. But do you mean just copy and paste the code in a message or would you want me to attach a working workbook. I don't know how to do that, I am still VERY new to this list, and I don't know the protocol.

    Thanks

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lotus Notes and MS-Excel (97 SR2i)

    When you are in the message edit screen, there is a text ox under the edit box that is labeled "Attach a file - 100k Max." under the edit box. There is a Browse button to the right of the text box. You can either type in the path and file name of the file or click on the Browse button and find your file. If you use the Preview button to look at your message before posting it, you will have to do this again in the Preview window.
    Legare Coleman

  5. #5
    Lounger
    Join Date
    Oct 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lotus Notes and MS-Excel (97 SR2i)

    Wassim, not sure if you had posted the VBA code for invoking Notes but I would be interested

  6. #6
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lotus Notes and MS-Excel (97 SR2i)

    Wassim,

    my apologies for missing this the first time round. The trick is to treat multiple recipients as an array.

    Dim MyRecipients As Variant
    MyRecipients = Array("brooke@work", "brooke@home")

    .........

    Call doc.SEND(False, MyRecipients)

  7. #7
    Lounger
    Join Date
    Oct 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lotus Notes and MS-Excel (97 SR2i)

    Brooke,
    Thanks, got that. Will try it out. I found the method I used only sent it to the first address of the list...ignoring the others. I appreciate the speedy reply...

Posting Permissions

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