By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,433 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

emailing reports

rcollins
100+
P: 234
I have been using the email reports feature in access. I have set up a macro with a preset address, so the database user clicks a button an the other guy gets the info he needs. Heres the problem. I have a comment field in the report which is set for memo (255 char). On the report itself, it looks good. As soon as I email it, it leaves off a portion of this feild. I am sending it using word. He needs to see the whole report, not 2/3 of it. Any suggestions?
Jul 24 '08 #1
Share this Question
Share on Google+
3 Replies


P: 78
Have you verified export of the report? What I mean is, in Access a report looks slightly different in an .rtf export(Word) then in the report visual within Access.

My suggestion would be to try exporting and play around with the report setup that way, rather then being visually acceptable within Access. Also, take note of your page size. When I first started I made it larger then an average Page with margins. Once I tweaked it to an 8.5x11 page with .5 margins it turn out great.

Hope this is helpful...Ultimately it takes a little time and patience to set it up to look right in Word export.

Nick
Jul 24 '08 #2

rcollins
100+
P: 234
I will give the margin thing a shot, that makes sense. I will be working on the database again in the morning since they are using it now. I'll let you know.
Jul 24 '08 #3

rcollins
100+
P: 234
Worked great, thanks for the response, sometimes as programmers we don't look for the obvious
Jul 29 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.