WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

email to multiple recipients

 
   Home -> Office other -> Reports RSS
Next:  SendObject report with a filter  
Author Message
sue gray

External


Since: Mar 08, 2007
Posts: 23



(Msg. 1) Posted: Wed Sep 03, 2008 9:18 am
Post subject: email to multiple recipients
Archived from groups: microsoft>public>access>reports (more info?)

I have a report that is currently being printed that I would like to be able
to email to individual employees. The report contains each employees time
summary on a separate page for each employee. I have done some research on
this site, but am still confused. Can someone point me in the right
diretion, please.
Back to top
Login to vote
Tony Toews [MVP]

External


Since: Jan 30, 2007
Posts: 2579



(Msg. 2) Posted: Wed Sep 03, 2008 9:13 pm
Post subject: Re: email to multiple recipients [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

sue gray <suegray.RemoveThis@discussions.microsoft.com> wrote:

>I have a report that is currently being printed that I would like to be able
>to email to individual employees. The report contains each employees time
>summary on a separate page for each employee. I have done some research on
>this site, but am still confused.

You will need to create a query containing the relevant records
including email addresses and fields necessary for passing to the
reports to select the appropriate records. Such as the primary key or
foreign key of the individual.

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Back to top
Login to vote
FMS Development Team

External


Since: Sep 14, 2008
Posts: 9



(Msg. 3) Posted: Sun Sep 14, 2008 5:54 pm
Post subject: Re: email to multiple recipients [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Sep 3, 12:18 pm, sue gray <sueg... DeleteThis @discussions.microsoft.com>
wrote:
> I have a report that is currently being printed that I would like to be able
> toemailto individual employees.  The report contains each employees time
> summary on a separate page for each employee.  I have done some research on
> this site, but am still confused.  Can someone point me in the right
> diretion, please.  

Hi Sue,

Check out our Total Access Emailer program.

Total Access Emailer is an Access add-in that lets you send
personalized emails to everyone in your list. From a table or query,
it can send emails to every email address and customize the message
and subject with field values from each record. I can also filter
data and reports to include that person's data in the body of the
message or attach it as a file.

In Access 2007, it can attach the Access report as a PDF file. Emails
can be in text or HTML format. You can also use the HTML output of a
report and make that the body of your message (this lets you use all
the power of Access reports to customize your entire message).

Total Access Emailer includes an interactive Wizard and a
programmatice interface for VBA developers so you can add it directly
in your code. A runtime library is available.

You can download a 30 day demo/trial version. For more info vsit
http://www.fmsinc.com/MicrosoftAccess/Email.asp

Good luck.

Luke Chung
FMS, Inc.
http://www.fmsinc.com
Back to top
Login to vote
Display posts from previous:   
       Home -> Office other -> Reports All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
 Office
  Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET