UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Multiple Emails, Every Email With One Report Send In One Time, Office 2010    
 
   
janis
post Oct 20 2011, 11:30 AM
Post #1

UtterAccess Addict
Posts: 137
hi

at this moment i can make a report.
and every customer get one report (this report need to be send to this customer as a html email)

but if i do it i have to open every customer click on report and then send it ..

maybe there is a better way?

here the sample database..


gr.
Attached File(s)
Attached File  test1.zip ( 724.83K ) Number of downloads: 2
 
Go to the top of the page
 
+
projecttoday
post Oct 21 2011, 01:35 PM
Post #2

UtterAccess VIP
Posts: 5,138
From: Dunbar, WV
In code, you can create a recordset from your customers table and loop through it and send each customer an email with code.
Go to the top of the page
 
+
janis
post Oct 21 2011, 01:55 PM
Post #3

UtterAccess Addict
Posts: 137
"end each customer an email with code."

what do you mean.. i need to write html code ????

isn't there a way to send the report?
i have the report how it need to be..

gr.
Go to the top of the page
 
+
projecttoday
post Oct 21 2011, 02:48 PM
Post #4

UtterAccess VIP
Posts: 5,138
From: Dunbar, WV
If you want to automate sending emails from the values in a table you will need VBA code.
Go to the top of the page
 
+
« Next Oldest · Access Automation · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 08:17 PM