@awais8845 Email templates are notoriously difficult and restricted because email clients just aren’t as sophisticated as modern web browsers. You can’t use modern CSS like Bootstrap.

There’s a reason Laravel’s default email templates are simple in design, and use HTML tables for layouts as if it’s still 1999.

@martinbean what about just we can edit body text content ?

Yes, you can create custom email templates using data from a database. Here's a general approach:

Design Templates: Create HTML templates for your emails. These templates can include placeholders or tags where dynamic data from the database will be inserted.

Database Integration: Fetch the necessary data from your database. This could be user information, order details, etc., depending on what you want to include in your emails.

Merge Data with Templates: Use a programming language like Python, PHP, or JavaScript to merge the data from the database with your email templates. Replace the placeholders/tags in the templates with the actual data fetched from the database.

Sending Emails: Utilize an email service or library (such as SendGrid, Mailgun, or PHPMailer) to send the personalized emails to the intended recipients.

For instance, in Python using a library like Jinja2 for templating and SQLAlchemy for database interactions, you might:

from jinja2 import Environment, FileSystemLoader from sqlalchemy import create_engine

Fetch data from the database

Example with SQLAlchemy

engine = create_engine('your_database_url') connection = engine.connect() result = connection.execute("SELECT * FROM users WHERE ...") # Query to fetch user data

Create an environment for Jinja2 templates

env = Environment(loader=FileSystemLoader('path_to_your_templates')) template = env.get_template('your_email_template.html')

Iterate through fetched data and render emails

for row in result: # Create context with data from the database context = { 'username': row.username, 'email': row.email, # Other data you want to include in the email }

# Render the template with the context
email_content = template.render(context)

# Send the email using an email service or library
# (code for sending emails goes here)

Remember, this is a basic example and might need adjustments based on your specific database structure, template design, and the programming language/library you're using. Always ensure that you handle sensitive data securely and comply with email sending guidelines and regulations.

Does this help? Are you looking for a specific language or database system for this task?