Email from a Form.

  • Thread starter Thread starter cappydixie
  • Start date Start date
C

cappydixie

Guest
I'm trying to email from an access form. I want to just email the current record/row that the user is on.

I have created a push button that calls a macro. The Macro uses the sendobject Action and I use the object type "Form". This sends all records/rows in the table as an attachment. Anyone know how to just send the current row as an attachment?
 
Hi Cappydixie

I am working on a someone elses database at the moment that has a macro that does what you describe. Not sure if this is going to fix your issue, as I didn't set it up but looking at it, I think it might!

The macro I have has 2 GoToRecord actions before the sendObject action. The forst GoToRecord specifies next in the record property and the second specifies previous. There is no current value available for this property so I assume this is how you acheive it.

Hope that helps!
 
Have a look at the attached sample, don't let its name put you off. It has examples of serveral items including e-mail.

You never print or email forms you create reports and use them to print or e-mail.
 
Last edited:
wow..nice...
thanks..help me alot..especially preview n print report..
 
eh..i think i lost sumting...
how to separate page?
i mean if i have small data, when i want to print it it show 2-3 page in 1 print page...
i want print 1 data page per print page...
thanks
 
Janjang,

What size page do you use in heaven? (your lcoation)

When preview a report does it show 2 pages? if so then you have to make sure that the page size is set to A4, if your have to use Letter size then you will have to change the page size in the reports, and adjust the page size of the report.


Hope this helps.
 
Great example altho i am having problems implimenting it into my database, but i will keep trying untill i admit defeat and ask for help. :P

If i can manage to get this to work then it will be great as i need both email and single report printing in my database.

So thanks, i will crack it in the end.
 
Thanks! This attachment appears in another thread (122244 & in this one), I got it from there earlier. Thanks again for your help!
 
You must log in or register to reply here.

Similar threads

T
Solved Attache files from main form to Outlook
Replies
11
Views
578
June7
June7
T
Attache to email from attachment Field
Replies
2
Views
416
theinviter
T
M
The proper ways of showing and hiding forms and reports.
Replies
8
Views
491
Pat Hartman
P
S
Solved Need help querying subform's combo box based on the main form.
Replies
13
Views
599
SkeletorPlus
S
A
Question Re: Modal Dialog form
Replies
7
Views
487
theDBguy
theDBguy

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom