Email with CC/ and Subject Line
but I want to add a CC email address and an automatic subject.
1) Private Sub SELECT_DblClick(Cancel As Integer)
2) FollowHyperlink "mailto: EMAIL ADDRESS"
3) End Sub
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The user has noticed that the resultant email cannot be minimised. The Maximise box works, as does the Close box, but although the Minimise button is present, it does nothing.
The hyperlink thing was simple but I think I need to use code to mark it as high priority and unfortunately I don't know code.
Currently we have an Access 2007 DB with a button on a form that opens up a new email with the subject and body filled in, all the user needs to do is click send in their default email application.
We now have discovered that although this email is helpful it really needs to contain some information from the form that has just been filled in. In particular there is a field called 'Business Name' and we would like the business name to appear in the subject of the email.
Is there anyway to do this with code, if we have to automate the email when the user clicks on the button rather than having to open up an email in their email client it does not bother me
When I click it I get an email with the right address and subject line, exactly as I need it, but I also get another blank email.
I've closed/reopened Outlook, and compacted and repaired Access db but it's still happening.
After I click the button, it first asks what type of file to send. I always want to send the reports as an .rft file, Next, it opens an email message and attaches the file.
What I would like to do here is add a couple of email addresses into the code so they prefill, along with a prefilled subject line and a small message in the body.
I still want the email message to show instead of automatically send.just in case something needs to be modified.
I need to send an email from Access 2007. I want to use an HTML file that is located at F:\Orbits Training Doc.html as the template for the email.
The subject line needs to be "Orbits Web Training"
I have a qry that is called myemailaddresses in which I need to use field "email" to populate the email address in outlook. The field will only have 1 result and not multiple.
If it makes it easier I could also use a .txt file as the body of the email but the HTML file is much cleaner as this is a communication that will be going out to customers
For example, lets say the field is call color and in that field I have selected Red. I want red to show up in the Subject matter in the email.
Take any thoughts on how I can do this