irishmanman
New Member
- Joined
- Oct 18, 2018
- Messages
- 1
Ready for a puzzle? I'm not fluent in VBA, and am hoping someone can point me rightly.
I'm trying to create a solution that takes the below table and sends an Outlook invitation automatically.
I have 200 rows, and don't update them all. So, it may be worth having a button for each row, so that as I update rows, I can click to create meetings as I go.
A) Will this spreadsheet become unruly?
B) Because I have so many rows, I'm worried about creating a bunch of buttons, and then if I insert a new row or column, it won't be clear which button ties to which row. Is there a cleaner way to do what I want?
C) Is there a resource I can use to create the code?*
*I found a few similar pages out there, but candidly, nothing in the format I needed or that I could understand. Thanks for reading, and I appreciate any guidance you can offer.
<!--StartFragment--> <colgroup><col width="82"> <col width="125"> <col width="55"> <col width="61"> <col width="55"> <col width="91"> <col width="75"> </colgroup><tbody>
<!--EndFragment--></tbody>
I'm trying to create a solution that takes the below table and sends an Outlook invitation automatically.
I have 200 rows, and don't update them all. So, it may be worth having a button for each row, so that as I update rows, I can click to create meetings as I go.
A) Will this spreadsheet become unruly?
B) Because I have so many rows, I'm worried about creating a bunch of buttons, and then if I insert a new row or column, it won't be clear which button ties to which row. Is there a cleaner way to do what I want?
C) Is there a resource I can use to create the code?*
*I found a few similar pages out there, but candidly, nothing in the format I needed or that I could understand. Thanks for reading, and I appreciate any guidance you can offer.
Subject | Body | Date | Start Time | End Time | Attendee | Macro |
JD to Call Mike | Discuss hard lemonade | 10/18/18 | 9:00 AM | 9:01 AM | bob@bob.com | Button 1 |
Mike to call JD | Discuss whiskey | 10/19/18 | 9:00 AM | 9:01 AM | mike@mike.com | Button 2 |
<!--StartFragment--> <colgroup><col width="82"> <col width="125"> <col width="55"> <col width="61"> <col width="55"> <col width="91"> <col width="75"> </colgroup><tbody>
<!--EndFragment--></tbody>