Emailing single record from a rather large form

[kyster]

Hi fellow Access battlers!

I've searched high and low on this forum on a step by step on how to do this and everyone's answer is either vague and assumes everyone is an access wizard, or really complex and codey and assumes every one is an access wizard!

I have a "lead sheet database" and I need to add a button on the form which emails just the contents of that current record. My company still handwrites these lead sheets and faxes them to consultants so I'm trying to bring them into the 21st century! An uphill struggle. I'm a code and VB newb by the way.

I've tried sending the form to a report as other posts suggest, but I get an error message about there being too many fields. So I'm stuck. All I need is for each form record to be emailed to a different consultant each day.

(I've had to rar then zip the database file due to size restrictions. I couldn't get the files size down enough by just zipping.)

Thankyou!

 

[ansentry]

Have a look at your sample now, it e-mails fine, no problem with the number of fields. When you send access reports in rtf format you loose a lot of the formatting ( as you will see). You have to make your report suit rtf format.

Have a look behind the e-mail button at the code, it is very very simple. To try it change the dud email address to your own and then save and click the email button, it will attach the report and then send it .

 

[kyster]

My goodness that was quick

ansentry...you are a legend! I wasn't expecting such a quick reply AND showing me the code already embedded in my database!
Thankyou! Thankyou! Thankyou!

 

[ansentry]

Kyster,

Thanks for your "thanks x 3", always go that extra yard for a fellow oz.

If you don't mind a suggestion make your report suit rtf format and then create a table for your consultants and you can then select (a) which ID report you want to send then (b) select from a drop down list of consultants the name of the consultant you want to send it to.

This is not as hard as it may appear, good luck with your project.