John O'Malvern
New member
- Local time
- Today, 00:11
- Joined
- Mar 25, 2024
- Messages
- 13
Until now the database generates a report of one A4 sheet per member which is ('printed' to pdf, and then) sent to someone else to print on paper. Some members require more than one different forms. (If the email process will work, then it won't matter that some members get unneccessary forms, everyone can get everything, and ignore what they don't need!)
The 2-4 sheets of paper have then been sent out by mail, so postage costs.
I'm hoping to do it all by email in December. I see there is help to generate emails with (as I understand it) individual pages from Access reports (e.g.) attached, e.g. to individuals (codekabinett.com/rdumps.php?Lang=2&targetDoc=send-email-access-vba-cdo and related webpages )
I would also like to send an image of a membership card, which presumably can be made as an Access report (so including the individual's Memb No and details, etc, as needed) my intention being that it can be downloaded onto a smart phone, and stored on the home page, to be clicked/tapped on to appear for showing when neccessary.
My problem (so far!) is i'm not sure how to go about this. Will the emailing techniques referred to send individual pages of a report to the appropriate recipients (I assume that is what it is there for) but does it need to go through a print to pdf stage before mailing out?
I would really appreciate being given a stage by stage overview of the process of setting up my system to do this. (I do have the full Outlook on my pc, so that's good, if needed.)
NB I'm not a programmer. I could copy and paste some code, obviously, and probably change some labels or variables for mine successfully. Otherwise I'm back to clicking my way through generating a macro.
Any help greatly appreciated.
John
The 2-4 sheets of paper have then been sent out by mail, so postage costs.
I'm hoping to do it all by email in December. I see there is help to generate emails with (as I understand it) individual pages from Access reports (e.g.) attached, e.g. to individuals (codekabinett.com/rdumps.php?Lang=2&targetDoc=send-email-access-vba-cdo and related webpages )
I would also like to send an image of a membership card, which presumably can be made as an Access report (so including the individual's Memb No and details, etc, as needed) my intention being that it can be downloaded onto a smart phone, and stored on the home page, to be clicked/tapped on to appear for showing when neccessary.
My problem (so far!) is i'm not sure how to go about this. Will the emailing techniques referred to send individual pages of a report to the appropriate recipients (I assume that is what it is there for) but does it need to go through a print to pdf stage before mailing out?
I would really appreciate being given a stage by stage overview of the process of setting up my system to do this. (I do have the full Outlook on my pc, so that's good, if needed.)
NB I'm not a programmer. I could copy and paste some code, obviously, and probably change some labels or variables for mine successfully. Otherwise I'm back to clicking my way through generating a macro.
Any help greatly appreciated.
John