Html

[shamas21]

Hi All

I have created an email sender in Access and I need to add a signiture but in different colours and font etc.... which means I have to to use .HTMLBody

But I dont know anything about HTML.

Is there a way around adding a signiture in the colours i want (i.e. some sort of HTML convertor) or call my default signiture from my Outlook 2007?

Thanks

 

[ajetrumpet]

i don't know about calling a default signature from access, but regarding the coloring and such, i would assume that you would have to incorp. HTML to do that stuff. when i did an email campaign not too long ago, i wrote a VBA script in outlook to loop the address book and send the emails. i used the .HTMLbody = "my first paragraph<br><br>my second paragraph<br><br>and so on...

if you do go with that, and you need the syntax for coloring, it is this:

"<font style='color:#0000FF'>my text here</font>"

remember, HTML written in VBA or VB script always has to be enclosed in quotation marks, even the opening and closing tags too.

the code above turns the font blue.

 

[shamas21]

i don't know about calling a default signature from access, but regarding the coloring and such, i would assume that you would have to incorp. HTML to do that stuff. when i did an email campaign not too long ago, i wrote a VBA script in outlook to loop the address book and send the emails. i used the .HTMLbody = "my first paragraph<br><br>my second paragraph<br><br>and so on...

if you do go with that, and you need the syntax for coloring, it is this:

"<font style='color:#0000FF'>my text here</font>"

remember, HTML written in VBA or VB script always has to be enclosed in quotation marks, even the opening and closing tags too.

the code above turns the font blue.

Many Thanks, That Helps.

One final question - It all well to use the HTMLbody to create pre-defined templates to send i.e.

Dear Mr Smith

Thank you for contacting etc....

but..

what if the user needs to write their own message then how do i know when to use the carriage returns i.e. <br><br> etc... theres no way to tell the computer when to put in the carriage returns i.e. the Enter spaces.. any ideas?

Thanks

 

[ajetrumpet]

shamas,

you haven't provided enuf info for me to give you a concrete answer to the ?. this is situational. i don't know how you are allowing your users to enter a message. typing it in OL? typing it in an access form? etc, etc...?

you'll have to create your own way. but keep in mind too, that the <p> tag is totally different than the <br> tag, in that the breaks are simply line breaks, whereas paragraph tags give you double line breaks.

i really elaborate unless you tell me how the users are writing messages, via a method above, or another. i have ideas, but that's fruitless without knowing that info.

i can tell you what i have done in the past, as it DOES prove very useful for automatic emailing and automatic system responses. if you are astute, or become astute in the future, you can really make use of the PHP mail() function, which is totally free, and gives you options to specify a whole bunch of criteria...sender, receipient, subject, etc...

I use it quite often for system generated emails, when i need to respond to a request for simply acknowledgment purposes. PHP would be a great thing to learn, as it is compatible with a lot of server platforms and has a load of VERY useful functions. Only downfall is that it's pretty difficult to learn, and it's entirely different than VB or VBA.

Anyway, i'm sure i'm rambling by now, but I've come to love java, PHP, HTML, etc... alot more than VBA, as I find it a whole lot more secure and more fun to tinker with too!

 

[ajetrumpet]

one other thing...if you don't know HTML or are having a hard time learning it, i suggest getting a program that edits internet documents (HTML. PHP, JSP, ASP, etc...) like dreamweaver, which is what i have. just like Access, Dreamweaver has the intellisense feature that GUIDES you along by "guessing" what you want in your code next. it was a useful tool for me when i started doing this stuff, and it still is. i go to it quite often, we can't remember everything! =) i highly recommend picking one up...