Go Back   Access World Forums > Microsoft Access Discussion > Macros

Thread Tools Rate Thread Display Modes
Old 09-21-2017, 12:55 PM   #1
Newly Registered User
Join Date: Apr 2017
Posts: 38
Thanks: 11
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
Coding Monkey Wanna-Be
BigHappyDaddy's Avatar
Join Date: Aug 2012
Location: Puyallup, WA
Posts: 203
Thanks: 6
Thanked 38 Times in 37 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

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 08:48 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

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