Format Access Data when sending to Outlook

[DomFino]

Hi everyone,
I have an Access application that sends email via a command button on a form. This works fine. What I am wondering is if there are commands in access to format the text being sent to outlook for Bold, Font Size, etc. In the code below, I would be bolding and resizing the headings between the double quotes.
Thanks,
Dom

'**gathers information from your form.  this sets the string variable to your fields
Email = "email person name"
ref = "Sourcer Updated With:" & " " & Me![code] & " Job Title " & " " & Me![desc]
origin = "NEW NEED FROM:" & " " & Me![o_company]
'destination = Me!destination
notes = "Sourcer Code  :" & " " & Me![code] & Chr(13) & Chr(13) & _
        "Job Title     :" & " " & Me!desc & Chr(13) & Chr(13) & _
        "Salary        :" & " " & Me!Salary & Chr(13) & Chr(13) & _
        "No. Vacancies :" & " " & NumberVacancies

 

[scking]

No, there is no Access solution to do this but anyone has the capability to 1.) create a rich text file and send it as a message, 2.) build the html and send it. You would be constrained by the settings the receiving Outlook client users. I believe most allow rich text/html messages but, if they only allow text, then they would see all the markings. There are probably more options but these were only two quite obvious ones. Either one would cause you to build the supporting solutions into your front-end and code.



---------------------
scking@arinc.com
---------------------

 

[DomFino]

scking,
Thanks for the reply. I quess I suspected there was no way to do this in Access but wasn't certain.
Thanks again,
Dom

 

[scking]

Well, that's not quite correct. I don't know anything you can't do using Access (that's a simplification), you just can't simply use an easy command to do this but would be required to build it into the application. For instance, drop a rich text control on a form and type on it to get your rich text then send the contents of the control or write a subroutine to create the html tags before shipping the message. What you need to determine is whether the time you would need to invest to build and test the enhancements would be worth the results. THATS the final go/no go determination.

---------------------
scking@arinc.com
---------------------

 

[DomFino]

scking,
Roger that!
Dom