+ Reply to Thread
Results 1 to 11 of 11

VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

  1. #1
    Registered User
    Join Date
    11-14-2017
    Location
    Brazil
    MS-Off Ver
    2007
    Posts
    8

    VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    Hi,

    I found here a excel file from Jarko28 user which contains a code that send a calendar entry meeting in Lotus Notes (link for the thread: https://www.excelforum.com/excel-pro...ith-macro.html).

    The code works, but when I put more than one attendee, it send only to the first person in the cell. For instance, in image below on the B2 cell there is two e-mails: [email protected] and [email protected] separeted by semicolon. The meeting entry sent only to [email protected]. How can I send to multiple attendees?

    image.png

    Here is the code:

    Please Login or Register  to view this content.


    Please, if someone can help me I will be eternal grateful!

  2. #2
    Registered User
    Join Date
    11-14-2017
    Location
    Brazil
    MS-Off Ver
    2007
    Posts
    8

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    Please, someone help me!

  3. #3
    Registered User
    Join Date
    11-14-2017
    Location
    Brazil
    MS-Off Ver
    2007
    Posts
    8

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    Please, may anyone help me?

  4. #4
    Registered User
    Join Date
    11-14-2017
    Location
    Brazil
    MS-Off Ver
    2007
    Posts
    8

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    Please, someone?

  5. #5
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    I sent a test meeting to 4 individuals at work, and it worked for me. However, I used a comma (,) instead of a semi-colon (;).

  6. #6
    Registered User
    Join Date
    11-14-2017
    Location
    Brazil
    MS-Off Ver
    2007
    Posts
    8

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    Did you put the full email adress like [email protected]? So did you put like below, with commas in the "Required Attendee"?

    [email protected], [email protected], [email protected], [email protected]?

  7. #7
    Registered User
    Join Date
    11-14-2017
    Location
    Brazil
    MS-Off Ver
    2007
    Posts
    8

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    Quote Originally Posted by Syrkrasi View Post
    I sent a test meeting to 4 individuals at work, and it worked for me. However, I used a comma (,) instead of a semi-colon (;).
    Please, help me! I tried with commas and it doesn't work.

  8. #8
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    Retesting...
    What (if any) error message did you receive?
    If your original question was resolved, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
    Click on the Add Reputation button (located at the lower-left corner of all post) for those who assisted you in solving your issue.

  9. #9
    Registered User
    Join Date
    11-14-2017
    Location
    Brazil
    MS-Off Ver
    2007
    Posts
    8

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    Quote Originally Posted by Syrkrasi View Post
    Retesting...
    What (if any) error message did you receive?
    I didn't received any error message, but it just send to the first person I put in the B2 Cell. The email of the second person appears on the line "Required Attendees" when I open the Invite on Lotus, but despite appears the email, just send to the first person. I check with my coleagues if they received the invite, but just the first person receives. Did you check if the coleagues in your work received the invitation?

  10. #10
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    This thread should be listed as solved since the OP found the solution in another forum.

    For those interested in accomplishing the same task, view below for the following code changes:

    Swap the following code
    Please Login or Register  to view this content.


    With this code
    Please Login or Register  to view this content.

  11. #11
    Registered User
    Join Date
    07-25-2018
    Location
    Caransebes, Romania
    MS-Off Ver
    2010
    Posts
    1

    Re: VBA Lotus Notes Calendar Entry Meeting - Multiple Attendees

    Very helpfull the previous code.

    Still have a issue, related to location, I can't specify in meeting the location for meeting.

    I would appreciate any help.

+ 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. [SOLVED] Calendar entry meeting in lotus notes calendar with macro
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-16-2016, 05:45 AM
  2. excel to lotus notes calendar reminder
    By zzanghongyuan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2015, 01:11 AM
  3. Outlook Meeting Invites - easiest way to add attendees
    By Amphibia07 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 07-24-2013, 08:11 AM
  4. Reminder in lotus notes calendar - not working
    By abo in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-22-2013, 02:34 AM
  5. Sending meeting requests through Lotus notes using Excel Macros attachment not working
    By praveen2825 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2013, 10:33 AM
  6. Sending meeting requests through Lotus notes using Excel Macros
    By praveen2825 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 02:08 AM
  7. Importing CSV or XLS files into Lotus Notes Calendar
    By MichaelJ in forum Excel General
    Replies: 1
    Last Post: 04-07-2005, 11:06 AM

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