OK guys
I can send emails with attachements - all hunky dory
now i want to step it up a bit
I want to make the body of my email - have the information that my reports would .. (and some simple formatting) -
the number of information fields is quite high
let say 30-40 fields ranging from numbers
ie. refernce number
value fields ( currency values)
text fields and memo fields (not many)
plus some "fixed text "
my basis email looks like = and I don't think i can add any more fields into it (its a bit messy - but the end result does what I want ....) is there a number limit of fields I can add ? -if so is there a better route to take
EmailSend.HTMLBody = _
"<p>" & "For the Attention of :-" & ![POC] & " </p>" _
& "Insured :-" & ![Insured] & "<BR>" & "Event :-" & ![Eventname] & "<BR>" _
& "Dates :-" & ![openfrom] & "<BR>" & " To " & ![opento] & "<BR>" & "Venue :-" & ![venuename] & "<BR>" _
& "<h1>" & ![Text184] & "</h1>" _
& bq & bq & "<b>" & ![BoldP1] & "</b>" & bqe & bqe & bq & bq & ![Text151] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP2] & "</b>" & bqe & bqe & bq & bq & ![Text155] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP3] & "</b>" & bqe & bqe & bq & bq & ![Text157] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP4] & "</b>" & bqe & bqe & bq & bq & ![TextPar4] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP5] & "</b>" & bqe & bqe & bq & bq & ![TextPar5] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP6] & "</b>" & bqe & bqe & bq & bq & ![TextPar6] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP7] & "</b>" & bqe & bqe & bq & bq & ![TextPar7] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP8] & "</b>" & bqe & bqe & bq & bq & ![TextPar8] & bqe & bqe _
& "<p>" & ![AccounthandName] & " </p>" & bqe & ![Accounthandtitle] & bqe & ![AccEmail] & bqe & ![accTel] & bqe & ![AccFax] & bqe _
& "<p>" & ![Webaddz] & " </p>" & bqe & bqe _
& "<p>" & ![AccountHandsignoff1] & "</p>" _
& "<p>" & ![accountHandsignoff2] & "</p>" _
& "<font size=""2"">" & ![accountHandsignoff8] & "</font>"
I can send emails with attachements - all hunky dory
now i want to step it up a bit
I want to make the body of my email - have the information that my reports would .. (and some simple formatting) -
the number of information fields is quite high
let say 30-40 fields ranging from numbers
ie. refernce number
value fields ( currency values)
text fields and memo fields (not many)
plus some "fixed text "
my basis email looks like = and I don't think i can add any more fields into it (its a bit messy - but the end result does what I want ....) is there a number limit of fields I can add ? -if so is there a better route to take
EmailSend.HTMLBody = _
"<p>" & "For the Attention of :-" & ![POC] & " </p>" _
& "Insured :-" & ![Insured] & "<BR>" & "Event :-" & ![Eventname] & "<BR>" _
& "Dates :-" & ![openfrom] & "<BR>" & " To " & ![opento] & "<BR>" & "Venue :-" & ![venuename] & "<BR>" _
& "<h1>" & ![Text184] & "</h1>" _
& bq & bq & "<b>" & ![BoldP1] & "</b>" & bqe & bqe & bq & bq & ![Text151] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP2] & "</b>" & bqe & bqe & bq & bq & ![Text155] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP3] & "</b>" & bqe & bqe & bq & bq & ![Text157] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP4] & "</b>" & bqe & bqe & bq & bq & ![TextPar4] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP5] & "</b>" & bqe & bqe & bq & bq & ![TextPar5] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP6] & "</b>" & bqe & bqe & bq & bq & ![TextPar6] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP7] & "</b>" & bqe & bqe & bq & bq & ![TextPar7] & bqe & bqe _
& bq & bq & "<b>" & ![BoldP8] & "</b>" & bqe & bqe & bq & bq & ![TextPar8] & bqe & bqe _
& "<p>" & ![AccounthandName] & " </p>" & bqe & ![Accounthandtitle] & bqe & ![AccEmail] & bqe & ![accTel] & bqe & ![AccFax] & bqe _
& "<p>" & ![Webaddz] & " </p>" & bqe & bqe _
& "<p>" & ![AccountHandsignoff1] & "</p>" _
& "<p>" & ![accountHandsignoff2] & "</p>" _
& "<font size=""2"">" & ![accountHandsignoff8] & "</font>"