Hello i want to create a button, and when a user clicks it, an email template from outlook will pop open with default list of people to send to and a filled in subject line. id appreciate any help thanks!
Hello i want to create a button, and when a user clicks it, an email template from outlook will pop open with default list of people to send to and a filled in subject line. id appreciate any help thanks!
There is lot out there on this topic. Google: VBA Access Outlook email multiple addresses.
Here is a recent thread on the topic https://www.accessforums.net/import-...ort-18235.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
thanks! i was able to solve this
actually, i was able to get the email open but how do i add more stuff to the body? such as how do i make it so i can go to the next line of the email without having to continue from the first line? also, how would i make something bold or another font color? or italicis? thanks
Do you want to build the body from data in database or just hard-coded in the procedure, like:
.HTMLBody = "This is my message with multiple lines." & Chr(10) & Chr(13) & "This is second line."
Assigning color and fonts I think requires HTML tags. Never tried that. See http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
hello, i tried using that line of code but it still writes it on the same line? also im not sure if this has anything to do with it but im usign access 97 and it wont recognize the olFormatHTML from that link when i put in:
.BodyFormat = olFormatHTML
I have never used Access 97. If it won't work with HTML then don't know if you can do what you want. Although I have not tried using HTML tags in email code, I have tested the CR LF codes with success in Access 2007.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
i see, thats ok. thanks for the help anyways!