Email with CC/ and Subject Line

I only use basic/easy codes to make my databases run more efficiently, I depend mostly on Macros. Can anyone help with a basic code to add a "CC" and "Subject" line to an outlook email populated from a command button?

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

Sponsored Links:

Related Topics

VBA check for email subject line
Is there a way to get access to check to see if an email is present by looking at the date or subject line? If it is there I want to go ahead and kick off an autoexec macro.


Email Sent Using Docmd.Sendobject
I am using a DoCmd.SendObject command to send an email; the code fills in a Bcc list and the subject line if the user has supplied one or, if not, leaves the subject line blank.

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.


Send email from form with subject line and marked as high priority
I need a button in a form that will send an email marked as high priority with predefined text in the subject field. I put an email hyperlink in the form with the subject line, but now I've been asked to have the email marked as "high priority".

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.


Send Email
I see where you can send an object by email in Access, but I'd like to have the code to send an email by just having the button when clicked, collect the name from the "RequestorsName" fieldand have the subject line say whatever and the body of the email say whatever; how can I do that?


Generate email with fields used on form
I was not sure how to simply word what I am trying to do so here is the longer version.

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


Program Link to Outlook Email from a Buttom
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


Email code creates an extra blank email
I've used other threads here to learn how to create Outlook emails and the following is almost working. The "button" is actually an image (which I forgot to rename!) on thedetail section of a continuous view form which displays relevant email addresses against data.

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.

[CODE]

I've closed/reopened Outlook, and compacted and repaired Access db but it's still happening.


Email Button Code
I have created a button in Access that when clicked I would like it to email the respective report to a group of email addresses. I used the wizard to do this, but I would like it a little more automated.

[CODE]

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.


VB Code to send an email
This is my very first post after searching and not finding what I need.

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.

Someone help!

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


Send email command with a twist
I have accomplish everything in sending a object in a email. Now for the twist. In the subject matter, I woud like to include three fields. Is there a way to where I can do this?

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


Email to outlook based off fields in a form
I have it set to where I can send an email and compile the subject and part of the body via clicking a button on the form. Problem is I have to manually enter the email address in the code and I want it done automatically via the combo box I have that updates my list box, also I want the list box data that is pulled to go into the body of the email as well. Here is the code that I have built thus far. The combo box only list the tech number but I have a query that references the tech number to the correct email address. Any help is greatly appreaciated!

Private Sub Command12_Click()
Dim subject As String, Body As String
subject = [Text2]
Body = [Text1] & Chr$(13) & [Text3] & Chr$(13)
DoCmd.SendObject , "Send an email", acForm, "Email Receipint Here(want this to be automatically filled based of the value of the combo box), , , subject, Body, False


Email to outlook based off fields in a form
I have it set to where I can send an email and compile the subject and part of the body via clicking a button on the form. Problem is I have to manually enter the email address in the code and I want it done automatically via the combo box I have that updates my list box, also I want the list box data that is pulled to go into the body of the email as well. Here is the code that I have built thus far. The combo box only list the tech number but I have a query that references the tech number to the correct email address. Any help is greatly appreaciated!

Private Sub Command12_Click()
Dim subject As String, Body As String
subject = [Text2]
Body = [Text1] & Chr$(13) & [Text3] & Chr$(13)
DoCmd.SendObject , "Send an email", acForm, "Email Receipint Here(want this to be automatically filled based of the value of the combo box), , , subject, Body, False


Read saved email in vba
I have an email message on my hard drive (c:\email.msg). How can I open it in Access VBA to parse the properties of the email (subject, body, etc


Send Object to addresses in table
I'm trying to use the Send Object command in a macro to send order confirmation emails to my customers. The body of the email will be the same for all addresses but the subject should have the PO number of the respective customer and his address only. The table that has the email address and PO number would look something like this:

Customer Name PO Number Email Address

Bob 12345 bob@email.com
Tim 12346 tim@email.com
Lucy 12347 lucy@email.com

Is there any way to get a single access macro to send 3 different emails using the same message body but with email subjects that look like this:

Subject: Your PO 12345 has been received (to Bob)
Subject: Your PO 12346 has been received (to Tim), etc


mymail.subject error
I'm trying to setup and email to automatically send on a specific date each month. Tehn once the email sends I want to log it in a table that ive created.

I've got the email to send alright but once I get to the logging part I get an error on mymail.subject - "The item has been moved or deleted."

MyTrackingTable.AddNew
MyTrackingTable("LogDate") = Date
MyTrackingTable("Subject_Task") = MyMail.Subject
MyTrackingTable("Loguser") = GetUserName()
MyTrackingTable.Update


send object help
I want a user to be able to click send email from my switchboard and have the utility do the following.

In the BCC: line I want to import email based on a simple query first and then they can fill out the rest when the new email screen appears. We have Access 2003 and it does recognizeour groupwise client and pull up an email screen but I need the BCC: line to populate the email addresses from my query.


Collect and update via email with a Table/spreadsheet
I would like to use the "Collect and update via email" function within MS Access which sends out and collects emails with MS InfoPath. I know how to use this function, but what I would like to do is something slightly different. Instead of emailing out a "form" that has the customer and then information below to be filled out, I want to send out an Excel/Access table instead.

The reason for this is because each email will contain 50+ subjects to fill out, each with 5+ items to fill out per subject. If I were to use the standard form, the person receiving the email would have to scroll through a very large email just to fill everything out. They also wouldn't be able to just go straight to the subject they are looking for without looking at the entire email. What I would like to do, is have them fill out a table or spreadsheet with the information, submit it, and then have those changes automatically entered into my table.


Send to Email message
As part of my database I have a table in which I keep a bunch of proforma email messages. It's very simple with 5 fields: an ID, receipient, purpose, subject line, body of text.

Can I program Access to send the standard text to an email message?

eg: I have hundreds of projects, some of which require external advice from a government department. My email proforma says (eg) "For Project <<ABC>> we have made a preliminary determination of <<xyz/not xyz>>. Please confirm our detemination."

Going through an email message and choosing the appropriate option of "xyz" or "not xyz" is not an issue; I would prefer to do that step manually. However, I would love to be able to push a code button that creates a new email message with the appropriate recepient; dumps in the standard text; AND the project details


Send email from form based on information on the from
My form is named "NotestoStaff" and it contains the following fields:

ID (an auto field)
Date Opened
Status
Note To
Note From
Re
Message

Once the fields are filled in I want to click send (a command button located on the form) and the Note to field will populate the email address in anew outlook email, the re field will populate the subject line, and the message field will populate the body of the email.

I prefer this than sending an object, but if this is not possible may have to resort to sending the object.


Email generated when new rec created
I want to notify certain people when a new record is created.

What is the code for that?

I just want to include the info from the new record and a string for the subject line