Data extraction system from email in Outlook, record creation in Excel with extracted data and form printing functionality for each record with variable fields.
Budget: $30 – $250 USD
What do I want to get.
When we receive an email in a specific folder of our Outlook, I want a VBA feature to extract the data that I
will specify later and insert them in the appropriate fields of an Excel sheet. The functionality must always
be active and compile the Excel file with the information automatically extracted upon receipt of each new
email without duplicates. The Outlook Folder where the emails in question are archived with a rule is called
“Assegnazioni GOL”.
The exact location of the Outlook folder is: \\Outlook\Posta in arrivo\Assegnazioni GOL\
For each of the records created in Excel, there must be the possibility, through a button positioned in
correspondence with the record, to print a form that contains the fields of the record and other
information preset in the form.
When we receive an email in a specific folder of our Outlook, I want a VBA feature to extract the data that I
will specify later and insert them in the appropriate fields of an Excel sheet. The functionality must always
be active and compile the Excel file with the information automatically extracted upon receipt of each new
email without duplicates. The Outlook Folder where the emails in question are archived with a rule is called
“Assegnazioni GOL”.
The exact location of the Outlook folder is: \\Outlook\Posta in arrivo\Assegnazioni GOL\
For each of the records created in Excel, there must be the possibility, through a button positioned in
correspondence with the record, to print a form that contains the fields of the record and other
information preset in the form.