469,954 Members | 1,780 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,954 developers. It's quick & easy.

Sending emails to multiple recipients

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
Mar 21 '06 #1
4 5163
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)

Mar 22 '06 #2
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
Mar 22 '06 #3
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

Mar 22 '06 #4
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.
Mar 22 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Norman Fritag | last post: by
4 posts views Thread by splicemix | last post: by
5 posts views Thread by horsetransport | last post: by
5 posts views Thread by Kun | last post: by
2 posts views Thread by Jeff Williams | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.