RE: send record via HTML EMail

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Bill then you use HTML tags to do your formatting.

For instance, if you want to bold your text you need to place it in between
bold tags
"<b>" & Me.FirstName & "</b>"

Check out the following site for more info on HTML tags.
http://www.w3schools.com/html/html_formatting.asp
http://www.w3schools.com/html/html_primary.asp
--
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.



"Bill" wrote:

This is what I have so far. How/where can I put the tags??:

Private Sub Command125_Click()
'Creates a new e-mail item and modifies its properties.

Dim olApp As Outlook.Application
Dim objMail As Outlook.MailItem
Set olApp = Outlook.Application
'Create e-mail item
Set objMail = olApp.CreateItem(olMailItem)

With objMail
'Set body format to HTML
.BodyFormat = olFormatHTML
.HTMLBody = "<HTML><BODY>Enter the message text here. & Me.[Check-out
Date] </BODY></HTML>"
.Display
End With

End Sub

"Daniel Pineault" wrote:

in your sub/function... you need to reference the various control on your
form to pull/push their values to build your HTML string.

For instance, if your have a textbox named "FirstName" and another named
"LastName" you would code it something like:

strHTML = Me.FirstName & " " & Me.LastName

Your can concatenate in the manner all your controls and build your HTML
message and create the layout you wish using HTML tags.
--
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.



"Bill" wrote:

OK. With help, I was able to get access to send an HTML email. Now I just
need to get the record to be passed. What values or inserts do I put in? I
know this is probably VERY simply
but I lost :-) Thx

.

Relevant Pages

  • Re: dynamic text with HTML markup
    ... formatting of text in the textframe. ... Formatting it to BOLD, ITALICS was ... for HTML tags and. ...
    (microsoft.public.powerpoint)
  • Re: How to "pre-format" text file output from a database to Word
    ... > (i.e. bold etc.) so that the text file will be treated correctly in ... There must be a way of "coding" the various Word attributes, ... Insert HTML tags and save the file with an .htm extension, ... interpret them when it opens the file. ...
    (microsoft.public.word.docmanagement)
  • Re: OT maybe: Looking for a tool or . . .?
    ... This will strip all the html tags out. ... is strip out the text in bold, remove the italic formatting, but leave ...
    (Ubuntu)
  • Word to HTML for Craigslist ad
    ... I need to write a few ads for Craigslist. ... much of the formatting is lost. ... just for the text and manually code the html tags, ...
    (microsoft.public.word.newusers)
  • Re: Using Words clipboard from .NET
    ... If you must hold on to the formatting, it wouldn't be difficult at all to ... HTML tags but then applies this formatting to the text via the Selection ... If you really want to use the clipboard, ...
    (microsoft.public.dotnet.framework.interop)