Hello,
Its been a while, I miss the world of excel!!
My current tricky position with excel/outlook, is always being out of sync with my appointments on my phone. I am going to use iCloud/google/outlook.com email with push… but I need the CSV to work from first.
I have a calendar in my outlook, which i can not share to my phone, without sharing each appointment individually.
I am sure it has been done before, I can't believe it hasn't… but I can't seem to find it anywhere.
What I need is some VB, using Excel 2007 as the controlling software.
During this scenario, both excel 2007 and outlook 2003 will be open.
1. Action Outlook to create CSV of existing calendar
2. clear two columns (to be defined) of contacts
3. Replace one column with new contact
4. Save CSV to Desktop, overwriting "Current Calendar"
5. Open New Mail
6. Attach CSV
7. Mail CSV to address (TBC)
Hope that all make sense.
Thanks
Craig
Open existing excel file (csv of existing calendar in outlook)
Its been a while, I miss the world of excel!!
My current tricky position with excel/outlook, is always being out of sync with my appointments on my phone. I am going to use iCloud/google/outlook.com email with push… but I need the CSV to work from first.
I have a calendar in my outlook, which i can not share to my phone, without sharing each appointment individually.
I am sure it has been done before, I can't believe it hasn't… but I can't seem to find it anywhere.
What I need is some VB, using Excel 2007 as the controlling software.
During this scenario, both excel 2007 and outlook 2003 will be open.
1. Action Outlook to create CSV of existing calendar
2. clear two columns (to be defined) of contacts
3. Replace one column with new contact
4. Save CSV to Desktop, overwriting "Current Calendar"
5. Open New Mail
6. Attach CSV
7. Mail CSV to address (TBC)
Hope that all make sense.
Thanks
Craig
Open existing excel file (csv of existing calendar in outlook)
