Create and Send emails from Access using an SMTP server

's Computer Specifications

I need to Create and send multiple emails with attachements (Excel and PDF),
to different recipients from Access using an SMTP server.

Is there anyway to code this in Access VBA?

Thanks,

Gerry

's Computer Specifications

Hi Gerry,

See Tony Toews's email FAQ at http://www.granite.ab.ca/access/email.htm

On Thu, 9 Jun 2005 14:46:02 -0700, "Gerry G."
<(E-Mail Removed)> wrote:

>I need to Create and send multiple emails with attachements (Excel and PDF),
>to different recipients from Access using an SMTP server.
>
>Is there anyway to code this in Access VBA?
>
>Thanks,
>
>Gerry

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot Send Emails.... SMTP Settings?	Noncentz	Microsoft Outlook Discussion	1	9th Jan 2009 08:30 PM
Smtp server not allowing to send emails	=?Utf-8?B?c2t5ZWRvbHBoYW4=?=	Windows Vista Mail	3	16th Nov 2007 10:06 PM
need smtp server to send emails in Outlook - can't use my ISP, Peo	=?Utf-8?B?TGlhbWU=?=	Microsoft Outlook Discussion	2	7th Apr 2007 11:58 PM
How do I create an Outlook Task from within my asp code & have the web server send it via SMTP	uofs76@yahoo.com	Microsoft Outlook Discussion	2	24th Jan 2007 11:19 AM
Re: Can see imap server incoming emails but can't send outgoing smtp e	Brian Tillman	Microsoft Outlook Discussion	1	4th Jan 2007 07:53 PM