How to add a new message template?

Hi,

is it possible to add a new message template? If so, can you provide sample code to send an email?

Thanks in advance!

Hi,

You can add a new message template using SQL-query to your database.

For example,

IF NOT EXISTS (
   SELECT 1
   FROM [dbo].[MessageTemplate]
   WHERE [Name]=N'YourMessageTemplate')
BEGIN
INSERT [dbo].[MessageTemplate] ([Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [EmailAccountId])
VALUES (N'YourMessageTemplate', NULL, N'%Store.Name%. Hello!', N'<p> Hi! This message from% Store.Name% </ p> ', 'true', 1)
END
GO

For 2.80.

Then you can edit it in the admin area.

Mariann wrote:

thanks.

and how can i call this new template ?
probably only from source code, right ?

Shay

Yes. If you want to use this message template to send, you need to edit the code.

Can someone please provide sample code?

What code do you mean?

Source code showing how to send an e-mail which is using a message template.
Thanks

To all: when suggesting or referring to a page or template item or otherwise to edit/modify, please, please, please be specific.
Which page name, located where?  With MVC there are often 2-4 places where code needs to be modified. And in nopC there are several cs pages that could be confused as which ones.  So, kindly, be specific.

@e-novative: If you would have read the post, you would see that nobody is suggesting or referring to a page or template item.
I was just asking for a simple code example, which shows how to send an email using a message template. Anyway, guess it's easier to look for that code by myself.

[email protected] wrote:

Agreed, som sample code about this would help alot with some explanation.