Emailing a Form

[BigDog]

I need help... I can not figure out how to email the form out in a clear
presentable layout. Right now I am using a macro

cmdEmailAssignedTo SendObject

In the message Text I've listed what I want sent, however it just comes out
in a single line display. I would like it formated and layed out nicely.
I've tried to link to a Template File but I have no clue what I'm doing.

Any help would be GREAT!!!

Thanks

 

[Daniel Pineault]

One method would be to create a report based on the current record and e-mail
it.

Another is to build a string based on the form control values and then use
the SendObject method to send an e-mail. You can lookup the SendObject in
the VBA help or search this forum, there are numerous examples.


Finally, if you want to get a little fancier, you can build a string based
on the form control values and use outlook automation to send the e-mail.
This option also allow the use of HTML tags... so you can layout the e-mail
using tables and font/italic/bold.... all the fun stuff html allows.

Which option tickles you fancy and we can look into it a bit further?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[BigDog]

Thats GREAT! I know HTML pretty well. How can I incorporate that?

Thanks for the help.

 

[Daniel Pineault]

For a basic Outlook function to send e-mails can be found at
http://www.devhut.net/index.php?lang=en&id=0000000013#AutoOlk

However, instead of using the .Body you will want to use .HTMLBody property
instead. As such, the variable you pass to it needs to be properly formatted
html. Take a look at the following link which cover the HTMLBody property in
more depth

http://msdn.microsoft.com/en-us/library/aa171418(office.11).aspx
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[BigDog]

This looks like what I want to do... I am just not getting it for some
reason. I was able to create a VB script to send the mail. The problem I
have with that is (I think) character limit on the line. I'm running out of
space on the line and I need to wrap it to the next line.

I would like to use HTML, but I just cant figure out how to call those
scripts. I took the script sample and put it into a blank file and tried to
play with it to work. It keeps coming back with an error and so far I can't
get it to work.

Still trying....