Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sendinf a access report automatic by mail

Status
Not open for further replies.
Niebotel

Niebotel

Programmer
Jan 1, 2007
169
NL
I created an invoicing module for our club. Each time 150 invoices are created. Now we want to send then via mail. I succeeded in it by using:
DoCmd.SendObject acSendReport, "Name of report", "pdf", EmailLid, , , "Factuur WSVBRU", "Bijgevoegd vindt U uw factuur voor WSVBRU; Gaarne binnen 14 dagen betalen"

This results in 150 emails in my email program; But now we have to send them away bij sending each email by opening and clicking on send email. Is there a way to send them directly from ACCESS?

The application finally runs in a runtime environment.
 
Status
Not open for further replies.

Similar threads

M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
422
SoftwareRT
SoftwareRT
Moss100
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
423
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
699
dhookom
dhookom
bobbyer
  • Locked
  • Question
Ms Access VBA Automatic Relinking Frontend to 2 Backend via form
Replies
13
Views
344
bobbyer
bobbyer
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
273
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top