From user parameter in Excel VBA code using SendGrid smtp

Question

Hi,

I am already using "in.hes.trendmicro.com" to send excel reports in email with "CDO.Message".
Now we need to change smtp to SendGrid.

When user receives email in mail box it shows "apikey on behalf of Test Report<xxx@xxxxxxxxxxxxx .com>".
I have mentioned "Test Report<xxx@xxxxxxxxxxxxx .com>" in from user & its working fine with "in.hes.trendmicro.com".

Any thoughts please.

Thanks

Answer 1

Hi,

Sorry for late response.
We have fixed the issue by using two separate users , one for senduser "apikey" parameter with its password & other for fromuser "Test Report<xxx@xxxxxxxxxxxxx .com>" parameter.

We were using one same user for both parameters at first.

Regards,

Answer 2

Hi,
I got below link while searching , this might help not confirmed, I will talk to my network team to make required changes, so lets see.

https://docs.sendgrid.com/ui/account-and-settings/how-to-set-up-domain-authentication