MikeC14081972
Programmer
Probably missing the obvious here, but here goes.
I need to build a routine that will build an email in Outlook from Access 2003 based on numerous recordsets.
In Lotus Notes it easy
Is there a way of doing the above in Outlook, i.e. append data to the body of an email one line at a time.
I can only find reference to building a string containing all the data and relevant HTML tags before applying to the mails body as a bulk drop.
Due to the length and required formatting in the mail this isn't really an option, so I would like to something like
If I was to use the above code the email body is empty as it will overwrite the body with each instance of .HTML = "blah blah blah"
If the above isn't possible I know I can us RichText instead so my question would then be how do I format each line of text as required using the below to append to the body
I hope that all makes sense, I know what I'm trying to say :lol: I'll worry about the numerous annoying security messages later.
Or should I get our mail client switched to Notes as it's so much simplier.
Thanks in Advance
I need to build a routine that will build an email in Outlook from Access 2003 based on numerous recordsets.
In Lotus Notes it easy
Code:
' After setting up the mail
with objNotesRTF
.AddNewLine 1
.AppendText "Line 1"
.AddNewLIne 1
.AppendText "Line 2"
......etc etc
end withIs there a way of doing the above in Outlook, i.e. append data to the body of an email one line at a time.
I can only find reference to building a string containing all the data and relevant HTML tags before applying to the mails body as a bulk drop.
Due to the length and required formatting in the mail this isn't really an option, so I would like to something like
Code:
.HTMLBody = "<html><body><b>Start of Message</b>"
.HTMLBody = "<br>"
.HTMLBody = "Second Line of email"
.HTMLBody = "<br>"
.HTMLBody ="<b><u>New Heading</u></b>"
.HTML = "</body></html>If I was to use the above code the email body is empty as it will overwrite the body with each instance of .HTML = "blah blah blah"
If the above isn't possible I know I can us RichText instead so my question would then be how do I format each line of text as required using the below to append to the body
Code:
.body = "Start of Message"
.body = .body & vbcrlf
.body = .body & "Second Line of Mail"
.body = .body & vbcrlf
.body = .body & "New Heading"I hope that all makes sense, I know what I'm trying to say :lol: I'll worry about the numerous annoying security messages later.
Or should I get our mail client switched to Notes as it's so much simplier.
Thanks in Advance
