Linking PDF files to emails.

[tcheck]

I have a client that has several users that need to send out multiple reports that are stored on a shared server drive. These PDF's are logged into a SQL database and the location of where they are stored each day and kept for several years. Is there a way to select several of these reports and attach them to an email that they can send off easily using Access 2010 or 2007?

[June7]

Review this for starters http://forums.aspfree.com/microsoft-...ro-447084.html

[tcheck]

I already send XLS files created in Access via email with out a problem. This would include going selecting files that have been already created and adding them to an email. Hard to explain but I thought i would give it a shot.

[June7]

What is your specific issue? How to send multiple attachments? How to get the file path reference from database? Maybe these will give some guidance

http://www.blueclaw-db.com/access_em...nd_outlook.htm
http://bytes.com/topic/access/answer...le-attachments

[AcsDb]

Private Sub ...()

...
MyPath = ...
MyFilename = ...
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon

Dim strBody As String
strBody = "... html tags are fine ..."

Set OutMail = OutApp.CreateItem(0)

OutMail.To = EmailList
OutMail.Attachments.Add MyPath & MyFilename
OutMail.CC = "...."
OutMail.Subject = "...."
OutMail.HTMLBody = strBody


OutMail.Display
Set OutMail = Nothing
....
End Sub

[tcheck]

THis is what I was looking for, to send an email with atttachments. I used the following site information just currious if anyone knows what the seperator is if I want to send several attachements;

http://www.blueclaw-db.com/download/...il_example.htm

Thanks for your help.

[June7]

There isn't one. Repeat the .Add for each file to attach. Review this http://www.pcreview.co.uk/forums/ema...-t3496042.html