Sending emails to multiple recipients

[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

[Steven Nagy]

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)

[I Don't Like Spam]

Michelle wrote:

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

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

[Cor Ligthert [MVP]]

Michelle,

You can use in my opinion Exchange interop (Mapi)

http://msdn2.microsoft.com/en-us/library/245421h5.aspx

Cor

"Michelle" <no****************@yahoo.com.au> schreef in bericht
news:dv**********@otis.netspace.net.au...

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

[Michelle]

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.