开发者

using macro to send reports via email with gridline borders between records

开发者 https://www.devze.com 2023-01-09 02:31 出处:网络
I do not knw VBA and would like to know if I can, with my limited knowledge,use the send-object command (or another comman开发者_开发问答d)to email Access reports,with gridline borders in between the

I do not knw VBA and would like to know if I can, with my limited knowledge, use the send-object command (or another comman开发者_开发问答d)to email Access reports, with gridline borders in between the fields in my output. I currently have the macro email format set to html.


If snapshot format is not an option for you (it requires that your users install a free utility), then you must build the html yourself in code, adding suitable tables. Given your previous question, this may well be the route to take, but it requires quite a bit of coding, though not necessarily in VBA.


As I am having the same problem, I have been looking around and creating an HTML or your own RTF document seems to be the way to go. RTF is not that complicated, but it still requires you to know BASIC programming.

Now, HTML is easy enough for me and I can easily add borders in HTML. (It's a bit harder in RTF syntax, to my point of view.)

Anyway, once you have that file ready, you need to send it and for that you need to somehow access MAPI or something of the sort. For that I found this page at Microsoft:

http://support.microsoft.com/?kbid=161088

It includes a sample function that sends a message of any size with any number of parameters in the header and any number of attachment. All of which cannot be done with the default SendObject function.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号