Suoritettu

VBA for Apps Outlook Project

Outlook folders in question:

'_Timesheets' - Email folder in the root of Outlook's folders.

There are 6 sub folders:

'Aldo Timesheet' - Subfolder of the above '_Timesheets' root folder.

'Erhan Timesheet' - Subfolder of the above '_Timesheets' root folder.

'James Timesheet' - Subfolder of the above '_Timesheets' root folder.

'Kevin Timesheet' - Subfolder of the above '_Timesheets' root folder.

'Natasha Timesheet' - Subfolder of the above '_Timesheets' root folder.

'Sergey Timesheet' - Subfolder of the above '_Timesheets' root folder.

'Timesheets' - Calendar folder in the root of Outlook's folders. This folder contains calendar appointments (not emails)

Scope of Work

I am looking for a VBA expert who can create a script that will:

1. Create appointments in the calendar folder called 'Timesheets' by copying any emails with the flag 'follow up today' in any of 6 subfolders of the email folder called '_Timesheets'.

2. Appointments should be copied to the date shown in the Subject line of the email (example: 1.0 Daily Timesheet - Aldo Colon Tue 5/4/2021)

3. Appointments need to retain the HTML formatting of the original emails.

4. Appointments need to retain the Subject from the original email as the Title of the appointment.

5. The Appointments’ times need to be set to All Day.

6. Appointments need to retain the color category of the emails copied from each of the 6 '_Timesheets' sub folders.

7. After copying any emails in any of the 6 subfolders to the 'Timesheets' calendar, the emails copied need to have their follow up status changed to 'mark complete’.

Taidot: Visual Basic for Apps

Näytä lisää: vba data outlook email, outlook vba export complete project, vba outlook particular information email, vba extractor outlook email, vba outlook macro read email addresses, vba outlook mapi field email address, vba outlook change subject email, vba excel outlook email excel file, vba outlook process lines email body received, vba outlook 2007 open email selected, email vba access outlook, vba function outlook email type, vba outlook process recent email days, vba search outlook email, outlook 2003 bulk email vba, outlook forward incoming email vba

Tietoa työnantajasta:
( 0 arvostelua ) Orlando, United States

Projektin tunnus: #30206722

Myönnetty käyttäjälle:

(43 Arvostelua)
5.1

2 freelanceria on tarjonnut keskimäärin $231 tähän työhön

maverick44000

Hello, I can develop a professional Outlook Addin to automate this appointment generation. VBA is a naive approach and prone to failure. Let me know if you are interested. Thank you, Usman

$350 USD 3 päivässä
(14 arvostelua)
5.3