Excel to Outlook Calendar Macro Development
Budget: $10 – $30 USD
I need a proficient Excel macro developer who can convert my team's schedule from an Excel sheet into a format compatible for Outlook calendar import. The schedule is currently structured as a single sheet with rows for each event.
Ideal skills for this job include:
- Advanced proficiency in Excel and Excel macros
- Experience with Outlook calendar
- Strong attention to detail
- Efficient coding skills to ensure quick turnaround
I have created a macro but it gives error I want to be able to share the macro to work on other computers and be more efficient.
Below I have provided the Original fields in the source excel sheet and where the data will go in the csv file for outlook conversion. I also have sample of working csv file that imports into outlook with no issues. I will provide all relevant data once we agree to work together.
Original Fields ----> Converted Fields
Case # - Description
Legacy Number - N/A
Hearing Date - Start Date (Needs to be converted from unrecognized date to mm/dd/yyyy)
Start Time - Start Time
End Time - End Time
Arbitrator - Description
Hearing Address - Location & Description (Needs to populate as a link in the outlook calendar)
Zip Code - N/A
City - N/A
Region - N/A
Applicant Attorney - N/A
Medical Provider - Subject & Description
Injured Party - Subject & Description
Respondent Attorney - Description
TPA - N/A
Carrier - Subject & Description
Expedited- N/A
MUA- N/A
Telephonic- N/A
Witness- N/A
Resource #- N/A
ClaimNumber - Description
In CSV file the fields and formatting will be as follows:
Subject: PROVIDER - INJURED PARTY - CARRIER
Start Date: HEARING DATE (MUST CONVERT TO MM/DD/YYY)
Start Time: START TIME
End Date: HEARING DATE (MUST CONVERT TO MM/DD/YYY)
End Time: END TIME
Description:
"ARBITRATOR: " - ARBITRATOR
"AAA# " - CASE NUMBER
"PROVIDER: " - MEDICAL PROVIDER
"INJURED PARTY: " - INJURED PARTY
"RESPONDENT ATTY: " - RESPONDENT ATTORNEY
"CARRIER: " - CARRIER
"CLAIM # " - CLAIMNUMBER
"LINK: " - HEARING ADDRESS (Needs to populate as a link in the outlook calendar)
Location: HEARING ADDRESS (Needs to populate as a link in the outlook calendar)
All Day Event: FALSE
Reminder: FALSE
Looking forward to your bids. Thank you.
Ideal skills for this job include:
- Advanced proficiency in Excel and Excel macros
- Experience with Outlook calendar
- Strong attention to detail
- Efficient coding skills to ensure quick turnaround
I have created a macro but it gives error I want to be able to share the macro to work on other computers and be more efficient.
Below I have provided the Original fields in the source excel sheet and where the data will go in the csv file for outlook conversion. I also have sample of working csv file that imports into outlook with no issues. I will provide all relevant data once we agree to work together.
Original Fields ----> Converted Fields
Case # - Description
Legacy Number - N/A
Hearing Date - Start Date (Needs to be converted from unrecognized date to mm/dd/yyyy)
Start Time - Start Time
End Time - End Time
Arbitrator - Description
Hearing Address - Location & Description (Needs to populate as a link in the outlook calendar)
Zip Code - N/A
City - N/A
Region - N/A
Applicant Attorney - N/A
Medical Provider - Subject & Description
Injured Party - Subject & Description
Respondent Attorney - Description
TPA - N/A
Carrier - Subject & Description
Expedited- N/A
MUA- N/A
Telephonic- N/A
Witness- N/A
Resource #- N/A
ClaimNumber - Description
In CSV file the fields and formatting will be as follows:
Subject: PROVIDER - INJURED PARTY - CARRIER
Start Date: HEARING DATE (MUST CONVERT TO MM/DD/YYY)
Start Time: START TIME
End Date: HEARING DATE (MUST CONVERT TO MM/DD/YYY)
End Time: END TIME
Description:
"ARBITRATOR: " - ARBITRATOR
"AAA# " - CASE NUMBER
"PROVIDER: " - MEDICAL PROVIDER
"INJURED PARTY: " - INJURED PARTY
"RESPONDENT ATTY: " - RESPONDENT ATTORNEY
"CARRIER: " - CARRIER
"CLAIM # " - CLAIMNUMBER
"LINK: " - HEARING ADDRESS (Needs to populate as a link in the outlook calendar)
Location: HEARING ADDRESS (Needs to populate as a link in the outlook calendar)
All Day Event: FALSE
Reminder: FALSE
Looking forward to your bids. Thank you.