Sending emails to multiple recipients

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

Hi

Is it possible/anyone know how to send a document (.pdf) to multiple
recipients using POP where the email is not just a matter of throwing 1000
email addresses in the BCC list, but each email is addressed personally..
ie: dear Harry...

I need to generate a subset of people via a query who have authorised to
receive information via email. Get those email addresses into outlook,
attach the document and then (if possible) personalise the email and send it
off.

Point to note: At this point I'm not sure if I will be using Access tables
as back end or SQL express

Any help is much appreciated.

Michelle
 
Wrong group. I can only tell you how to do this in .NET

In a FOR loop of all your people in a list, create an individual mail
message like this:

Dim NewMail As New System.Net.Mail.MailMessage(EmailFrom, EmailTo)
NewMail.Subject = EmailSubject
NewMail.Body = EmailBody
NewMail.IsBodyHtml = True ' unless of course its not.
' ... you get the gist, fill in all the fields you like
' add an attachment
Dim attachMe As New System.Net.Mail.Attachment(AttachmentPath)
NewMail.Attachments.Add(attachMe)
' Now send it
Dim sendmail As New System.Net.Mail.SmtpClient(SMTPServer) ' Get this
from your ISP
sendmail.Send(NewMail)
 
Michelle said:
Hi

Is it possible/anyone know how to send a document (.pdf) to multiple
recipients using POP where the email is not just a matter of throwing 1000
email addresses in the BCC list, but each email is addressed personally..
ie: dear Harry...

I need to generate a subset of people via a query who have authorised to
receive information via email. Get those email addresses into outlook,
attach the document and then (if possible) personalise the email and send it
off.

Point to note: At this point I'm not sure if I will be using Access tables
as back end or SQL express

Any help is much appreciated.

Michelle
Click to expand...

Why use outlook? .Net has email classes built into it.

http://www.google.com/search?hl=en&q=vb.net+send+email

Make the email, send it, loop through dataset.

Chris
 
Thank you both for replying. I will have a look further into what you both
suggest.

Steven I am writing this in .NET. Sorry for posting in the wrong group.
 
Back
Top