Sending emails to multiple recipients

21 Mar 2006 11:08 PM

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

22 Mar 2006 5:48 AM

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)

22 Mar 2006 5:50 AM

I Don't Like Spam

Michelle wrote:
Show quoteHide quote

> 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

22 Mar 2006 6:01 AM

Cor Ligthert [MVP]

Michelle,

You can use in my opinion Exchange interop (Mapi)

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

Cor

Show quoteHide quote

"Michelle" <nospam_mbytwo-news@yahoo.com.au> schreef in bericht
news:dvq112$dbn$1@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
>

22 Mar 2006 8:07 AM

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.