Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-21-2017, 12:55 PM   #1
HeatherO
Newly Registered User
 
Join Date: Apr 2017
Posts: 23
Thanks: 5
Thanked 1 Time in 1 Post
HeatherO is on a distinguished road
Emailing a Report

I have a table called "Applicants" which lists applicant names, email addresses, and property assigned. I want to add a button to my form which will automatically email a report to all applicants with the same "property assigned". I'm not very good at VBA so I've been using the "Create Macro" tool and have only been able to get it to send to the 1st record found in the table instead of all of the records with the same "property assigned". Any ideas?

HeatherO is offline   Reply With Quote
Old 09-21-2017, 01:08 PM   #2
BigHappyDaddy
Coding Monkey Wanna-Be
 
BigHappyDaddy's Avatar
 
Join Date: Aug 2012
Location: Puyallup, WA
Posts: 173
Thanks: 6
Thanked 36 Times in 35 Posts
BigHappyDaddy is on a distinguished road
Re: Emailing a Report

I admit, I never use the macro tool. VBA might have a steeper learning curve, but its flexibility and ability is far superior than anything you can create in a macro.

Also it sounds like you are stuck in the first record of a loop scenario. I honestly don't even know if loops are possible in a macro, but if they are, that is what you need.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
BigHappyDaddy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Emailing a report rikklaney1 Modules & VBA 4 10-15-2015 11:47 AM
Report view = 1 page (good), but VBA emailing same report = 4 pages (bad!) peskywinnets Reports 10 04-23-2015 12:26 PM
emailing report msnarayanan Reports 2 01-03-2007 03:15 AM
Headers in report are messed up when emailing the report Mae Reports 1 02-05-2004 12:55 PM
Emailing Report ekta Reports 6 12-17-2003 01:21 PM




All times are GMT -8. The time now is 12:28 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World