February 16, 2011 at 10:05 pm
Hi Everybody,
When I send an e-mail using database mail, the sender's name displayed on the e-mail is different from what is specified in the "Display Name" field for the account.
Following are the configuration details of my account:
E-mail address: ems@klog.in
Display name: Kotak Global Logistics Ltd.
Server name: 192.168.0.5
Port number: 231
SMTP Authentication: Basic authentication
The sender's name displayed on the e-mail is "ems" instead of "Kotak Global Logistics Ltd.".
Please advise the solution for this problem.
March 1, 2011 at 2:56 pm
Can you please suuply the TSQL code you're using?
Ex:
EXECUTE msdb.dbo.sp_send_dbmail @recipients = 'jdoe@gmail.com'
, @subject='Test', @body = 'Test'
Also, you may want to check the settings in >> Management >> Database Mail >> Manage Database Mail accounts and profiles >> View, Change, or Delete an existing account for the "Display Name"
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2011 at 1:57 am
Thanks for your reply!
Following is the TSQL that I am using:
EXEC sp_send_dbmail @profile_name='EMS', @recipients='utpal@srpfpl.com',
@subject='Test Message', @body='This is the body of the test message.'
The display name in Account settings is "Kotak Global Logistics Ltd.".
March 8, 2011 at 7:13 am
Can you set Email Address as Kotak Global Logistics Ltd. in account configuration. Try testing with test email.
I think mentioning your email address as ems@klog.in wouldn't matter.
M&M
April 13, 2011 at 5:02 am
Hi Mohammed,
I am not able to set the e-mail address to "Kotak Global Logistics Ltd.", because it is invalid.
April 13, 2011 at 12:45 pm
Thanks Utpal for letting me know
M&M
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply