I need some help with a database im planning to build.
I want to build a dB that saves the data that was put in emails of (EXTERNAL) contracters that are being sent out bij te Office Operation Center.
I was planning to build a dB where data is entered in forms and that stores the data in tables and when the adding of data is finished the total will generate an view that shows the total of the data that will need to be sent and after that
the sent mail-cmd do his thing.
The only thing i dont know how to get done is that i want the data that has been entered to be generated in a email instead of an attachmend that will be added to the mail.
Hope someone can give me some pointers to how this is done.
As a general rule, you can build the body of an email to be sent. Using a variable and getting values from the form the code is in:
strBody = "Dear " & Me.FirstName & " some more text here"
Basically you concatenate literal text with form values to build a finished product. You can get quite creative, using either vbCrLf or the combination of Chr(13) & Chr(10) for new lines. With some email methods you can also use HTML tags. You would then use the above variable in the chosen email method.
Oke that's familiar to me if converted the macro sent object but my question now is how do i make the mail gearing like a mail that is used at this time.
Now we use a template that look sort of like this:
And if i want to use lets say an enter then the string is broken how do i do that to make the mail similar.
No im sure im still getting the same problem i was at the beginning the only ting i can do when i use the sent object command im getting a mail with an object attachment of the form.
If i edit the string i get a mail with text without formation and not inserted the info that i need it....
O you dit indeed mentioned it sorry bout that...
That works fine, but what if i want to generate more lines of text end lets say a format with lines and collored text and hyperlinks???
But mainly the next lines...