need large message in Message Text of send object

[Andrew P.]

Hi All

I want to use SendObject to send an instruction message to contractors. The
form contains all the info I need to include in the email, but I want to have
more than a one line email.

How can I put a full message in that field? I want to have proper parragraph
spacing in with the form fields in the email.

Oh, Im using the builder too, not sure if its different when using VBA....

Thanks a lot
Andrew

 

[Roger Carlson]

You'll have to use Office Automation to do something like that. Here's a MS
Knowledgebase article about it:
http://support.microsoft.com/kb/209948/en-us

On my website (www.rogersaccesslibrary.com), in the Other Developers
section, are several Access database samples that might help. You can find
ther here:

AD Tejpal:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=52&KW=outlook&PID=52#52

Ron Hughes:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=179&KW=outlook&PID=179#179
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=178&KW=outlook&PID=178#178



--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Roger Carlson]

Addendum to my previous post:

I missed a few samples:

Jerry Whittle:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=26&KW=email

Mike Buraczewski:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=212&KW=email

 

[Andrew P.]

Thanks a lot Roger. One of the files had the clue I needed - "Chr$(13)" is
the same as hitting return - as Im quite new to all of this, I was not
aware...

I just converted the code to VBA then made several strings with the text I
need, then in the sendobject code, I used str1 & str2 etc.

Regards
Andrew