Access sending emails

[hinser13]

We have a CRM management system for managing quotes, invoices, work in prgrees and so on.

I am trying to find a way to get past a problems that I am currently struggling with!

Problem: What is the easiest way to send a client an email using the email field on the form and attach either the quote or an invoice.

I use this criteria in the query [Forms]![frmactionplatform]![ValueQuote No] to select the appropriate quote.

I am aware that I can use a macro "Send Object" and this works fine for attaching one report! I need to attach two reports to one email, any ideas?

 

[John Big Booty]

Perhaps this thread will help, or try one of these.

 

[smig]

I use Stephan Leban's DLLs to convert to PDF and VBSendMail.dll to send emails
both are free and work perfect for me

 

[MarkK]

See this thread for code that uses CDO, or Collaboration Data Objects, to directly send email without using any email client. On my machine the reference is called 'Microsoft CDO for Windows 2000 Library.' If it's not present on your machine, here's the dll.