Hi guys,
I currently have an excel worksheet that is set up with formulas so that it can quickly transform an input into a prescribed format and send it out via outlook email. However, the spreadsheet has grown considerably and this has made excel run a lot more slowly.
The transformation into a prescribed table format is done via excel formulas in excel currently. However, I realized it's not practical to replicate the same setup on excel in access as there are no such formulas.
May I know if there is a possibility of being able to quickly transform my inputs into a dataset and send them out via email to a bunch of people while logging the inputs in a main database?
I am very new to access and I am trying to figure out along the way. Thanks.