Create electronic newsletters and email to all people in an excel spreadsheet

DB Coordinator for CS · Jul 28, 2003

Hi Guys

We are using Windows platform and active perl in our organisation. We want
to create electronic newsletters(which embed images as well) and want to
mailout all the people whose email addresses are in an excel spreadsheet.
Can you give some advice about what modules/items we should use in Active
perl to create/mailout electronic newsletters?. How can we achieve this
task?. Are there any particular way to do this in active perl?. What
modules/sections of Active perl we should need?.Can you give some reference
or help?

Thank you
Jo

Gregory Toomey · Jul 28, 2003

DB Coordinator for CS said:
Hi Guys

We are using Windows platform and active perl in our organisation. We want
to create electronic newsletters(which embed images as well) and want to
mailout all the people whose email addresses are in an excel spreadsheet.
Can you give some advice about what modules/items we should use in Active
perl to create/mailout electronic newsletters?. How can we achieve this
task?. Are there any particular way to do this in active perl?. What
modules/sections of Active perl we should need?.Can you give some reference
or help?

Thank you
Jo

Heres a couple of simple examples of sending email as HTML using MIME::Lite.
You could put your newsletter in HTML format.
Also see http://search.cpan.org/dist/MIME-Lite/lib/MIME/Lite.pm
The easiest way to get the email addresses from Excel is cut/paste into
notepad.

#!/usr/bin/perl
use strict;

require MIME::Lite;
require MIME::Lite::HTML;

my $msg;
$msg = MIME::Lite->new(
To =>'(e-mail address removed)',
From =>'(e-mail address removed)',
Subject =>'HTML with in-line images!',
Type =>'multipart/related'
);
$msg->attach(Type => 'text/html',
Data => qq{ <body>
Here's <i>my</i> image:
<img src="http://asdasd.com.au/images/asdasd.gif">
</body> }
);
$msg->send;

my $mailHTML = new MIME::Lite::HTML
From => '(e-mail address removed)',
To => '(e-mail address removed)',
Subject => 'test';

my $MIMEmail = $mailHTML->parse('http://asdsad.com.au');
$MIMEmail->send;

gtoomey

DB Coordinator for CS · Jul 29, 2003

Gregory Toomey said:
Heres a couple of simple examples of sending email as HTML using MIME::Lite.
You could put your newsletter in HTML format.
Also see http://search.cpan.org/dist/MIME-Lite/lib/MIME/Lite.pm
The easiest way to get the email addresses from Excel is cut/paste into
notepad.

#!/usr/bin/perl
use strict;

require MIME::Lite;
require MIME::Lite::HTML;

my $msg;
$msg = MIME::Lite->new(
To =>'(e-mail address removed)',
From =>'(e-mail address removed)',
Subject =>'HTML with in-line images!',
Type =>'multipart/related'
);
$msg->attach(Type => 'text/html',
Data => qq{ <body>
Here's <i>my</i> image:
<img src="http://asdasd.com.au/images/asdasd.gif">
</body> }
);
$msg->send;

my $mailHTML = new MIME::Lite::HTML
From => '(e-mail address removed)',
To => '(e-mail address removed)',
Subject => 'test';

my $MIMEmail = $mailHTML->parse('http://asdsad.com.au');
$MIMEmail->send;

gtoomey

DB Coordinator for CS · Jul 29, 2003

Thanks Greg. This really helped me. I couldn't install the MIME::Lite::HTML
module. I use ppm for module installation. I was able to install only
MIME::Lite.

Cheers
Jo

Gregory Toomey · Jul 29, 2003

DB Coordinator for CS said:
Thanks Greg. This really helped me. I couldn't install the MIME::Lite::HTML
module. I use ppm for module installation. I was able to install only
MIME::Lite.

Cheers
Jo

When I did this last your I installed the two modules in a local directory.
My ISP at the time did not have them installed.

gtoomey

How to import Excel spreadsheet contacts into Google Contacts or iCloud?	0	Jul 28, 2025
How to Import Excel Files to iCloud for Easy Access	0	Jan 23, 2025
How to Make CSV Contact Files Work Seamlessly Across All Smartphones?	0	Sep 17, 2025
Hello all! Noob here with completely unrealistic ambitions. Happy to join the crew and get good enough to help others.	4	Aug 13, 2024
Spreadsheet::Parse & Write Excel	1	Oct 30, 2007
Modifying an existing excel spreadsheet	2	Dec 20, 2010
How to control an already open spreadsheet	2	May 14, 2008
[ANN] spreadsheet-excel-0.3.5.1	0	Feb 8, 2007

Create electronic newsletters and email to all people in an excel spreadsheet

DB Coordinator for CS

Gregory Toomey

DB Coordinator for CS

DB Coordinator for CS

Gregory Toomey

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads