shashikr2011
New Member
- Joined
- Nov 18, 2011
- Messages
- 1
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I am trying to link excel with outlook calendar and also reached half the way. Where i could get the required details (Subject, date, time, Invite attendees etc) in my calendar. But i am struck with following 2 problems<o></o>
<o></o>
1) when i write .send command in macro, invite is automatically not sent to the recipient and i have to manually click on send button to send the invite.<o></o>
2) if there are multiple items at multiple time and dates in excel (eg. Open Vs closed- i want to send invite to all those for whom category is showing as open at different time and date slots), all multiple (Open) items are not coming in the loop -even after using if command.<o></o>
<o></o>
<o></o>
Has anyone have this kind of macro available.<o></o>
<o></o>
fficeffice" /><o></o>I am trying to link excel with outlook calendar and also reached half the way. Where i could get the required details (Subject, date, time, Invite attendees etc) in my calendar. But i am struck with following 2 problems<o
></o><o
></o>1) when i write .send command in macro, invite is automatically not sent to the recipient and i have to manually click on send button to send the invite.<o
></o>2) if there are multiple items at multiple time and dates in excel (eg. Open Vs closed- i want to send invite to all those for whom category is showing as open at different time and date slots), all multiple (Open) items are not coming in the loop -even after using if command.<o
></o><o
></o><o
></o>Has anyone have this kind of macro available.<o
></o><o
></o>
