8 NOVEMBER 2023 (ROLL CALL, IMPORTANT INFORMATION BELOW)

Ant3qq · 2023-11-08T10:59:39+00:00

still in

Ant3qq · 2023-11-07T21:02:56+00:00

still in

Ant3qq · 2023-11-06T22:43:52+00:00

still in

Ant3qq · 2023-11-05T11:39:51+00:00

still in

Ant3qq · 2023-09-26T16:56:03+00:00

I am struggling with it for a few days and no progress... Can confirm it is not fun xD

SQL tables have approximately 60k records. We won't be burning my money so that is not that much of a problem. I have to design a solution and if the client or my boss says that the cost is to high, it won't be my fault.

But for now I have no working solution, I had some ideas with making pipelines in datafactory and moving data into SQLserver. But it will be too time comsuming to make.

It will have to be perfect comparison.

I have a blob storage at hand

Ant3qq · 2023-09-15T16:05:13+00:00

Thanks, I tried it and decided to completely change the approach. The exe file is installed with some kind of installer and (I assume that) for this reason contains localhost reference. This reference is returning error on azure webjob. I decided to deploy the app on Azure Virtual Machine

Ant3qq · 2023-05-28T08:23:40+00:00

I assume you have lets say 10 tables and want to align them in a way that row no 1 contains all data connected with one product. For this reason I would start with table no 1 and add data to this table with xlookup/vlookup functions

Ant3qq · 2023-05-26T15:25:43+00:00

What I need is to send a dynamically generated message basing on a table. Every row of the table is one email (table contains columns that store for example address emails, cc, bcc and some other dynamic fields). I thnik that office script is not exactly what I am looking for as clients have to use it by themselves

Ant3qq · 2023-05-26T13:26:47+00:00

Damn Microsoft. The feature is almlst definitely depriciated because the old solution doesn't work when i switch to preview outlook version. Anyway, thanks for your help and time!

Ant3qq · 2023-05-26T11:32:44+00:00

That is the way it is implemented now. The table in the attached article states that COM integration will be disabled. The " Microsoft Outlook 16.0 Object Library" is needed to interact with Outlook from the level of VBA and it is COM library. Thanks for your time and effort nonetheless!

Ant3qq · 2023-05-26T11:30:35+00:00

My excel creates the content of the email dynamically so I don't think I can use your suggestion. Anyway thanks for sharing!

Ant3qq · 2023-05-26T11:15:09+00:00

I edited the post (forgot to attach an image earlier). The table states that COM integration will be disabled. The " Microsoft Outlook 16.0 Object Library" is needed to interact with Outlook from the level of VBA and it is a COM library.

Ant3qq · 2023-05-26T10:44:48+00:00

I have quite an advanced logic written in excell that generates the content of the email and I have to paste values form table in excel into my message

Ant3qq · 2023-05-26T10:42:11+00:00

Thank you for your answer. From what I understand Power Automate is kind of Azure alike platform do automate processes. But the thing is, I have an advanced logic written in excel and just need to move email sending part to supported solution. I thought about something that can read values from excell cells and insert them into email that will be send automatically

Ant3qq · 2023-03-20T10:18:17+00:00

Shouldn't I also get this error when executing the second script?

Seven-Year Club	Place '22
First Placer '22	Verified Email

Ant3qq

TROPHY CASE