Topics Search

Email with CC/ and Subject Line

Email with CC/ and Subject Line
Views: 17
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:

Similar posts...


Email Sent Using Docmd.Sendobject

Email Sent Using Docmd.Sendobject Icon
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

Send email from form with subject line and marked as high priority Icon
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

Send Email Icon
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?

Email code creates an extra blank email

Email code creates an extra blank email Icon
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.


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

Email Button Code

Email Button Code Icon
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.


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.

Send email command with a twist

Send email command with a twist Icon
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

send object help

send object help Icon
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

Collect and update via email with a Table/spreadsheet Icon
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 email from form based on information on the from

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

ID (an auto field)
Date Opened
Note To
Note From

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.

adding attachments to a vba generated email

adding attachments to a vba generated email Icon
I'm after an add on to my current email generating code that will add an attachment (always located at the same file path) to my email.

my current code that is applicable to this part is

DoCmd.SendObject acSendNoObject, "", actext, "email at", "", , "subject", strText