Hello,
We could create an excel VBA macro that will use an input sheet in order to automatically process the text to create hyperlinks with a single click.
Ideally we would try(depends on mac rules) that after the processing is done everything to be automatically copied in clipboard.
This way you will simplify the process to 3 steps:
1. Paste the data in input tab
2. Press the button “Process”
3. Go to email and paste directly
My last VBA work includes:
- tool that automatically prepares PDF invoices using complex calculations
- tool that send emails automatically for each team leader containing only his team members+custom attachment
- import of one excel file within another in order to be processed following some configurable parameters
- vba tools with multiple forms, transfer data between windows forms
- data processing and reconciliation
Don’t hesitate to contact me on chat to discuss the solutions for your project.
Regards,
Marius