Can you apply style formats to Outlook emails, etc, from Access? 1

[Najemikon]

Hi,

I have several forms with buttons that can send fields to emails, tasks & appointments in Outlook. Very simple & works a treat. For example:

outlook subject = field1
outlook memo = "Dear " & field 2 & vbnewline & vbnewline & field 3


I'd like to add more details, but so the resultant Outlook object doesn't appear cluttered, I'd like format it; smaller fonts, headings in bold or italic. Maybe even colours!

Is this at all possible?

 

[mordja]

Most likely, you will need to create an outlook application object and include the outlook object library.

Mordja

 

[PHV]

In order to do some formatting stuff you may take a look at the HTMLBody property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Najemikon]

It did indeed, PH! Instead of '.body' you use '.HTMLbody' & then you can apply standard formatting codes. Why is it the things that seem the most complicated turn out to be really straightforward?

Course, now you've helped me unlock all sorts of colours, fints, sizes, etc, I've let it go to my head & rather than uncluttered emails, I'm going to have a retro 70s feel to the whole affair! It can only end in tears.