sending data into an email body - outlook

I have a query where I collect data for different vendors and their purchase orders, products deadlines etc.
Is it possible via access to generate a report and via outlook send in the email body a message where is showing the purchase order date of delivery and priority?
or can that be done via a form?¨

Sponsored Links:

Related Topics

sending data into an email body - outlook
I have a query where I collect data for different vendors and their purchase orders, products deadlines etc.
Is it possible via access to generate a report and via outlook send in the email body a message where is showing the purchase order date of delivery and priority?
or can that be done via a form


Access 2010 - Sending emial (VBA or Macro)
I am a novice with access.I have spend most of the day today scouring the internet, and also searching through this forumn for help with sending emails with Access 2010. Let me get right into.

I want to be able to email the content of a table/form/or query as an email, as a caveat I want the body of the email structure using the layout and format of an existing outlook 2010 form.

Example:
Table A
Task
Emp R
Date

I want to set up the body of the email using the info above

so the email body would read like this

Notice of Task completion

Task: "Table A.Task
Employee: Table A. Emp R
Completion Date: Table A. Date

"do not reply to this message"


Variable Email of a Report
However I am new to access and I have a little situation. My client wants to be able to send a email out which is a report generated invoice of her customers purchase.

This part is all set and ready to go. the query and report creation are taken care of and work great for printing.

now I need to add a cmd button to send a email that pulls the customers email address and fills it in. Sending the email is easy. however pulling the email address data from the customer tbl is where I need some assistance.

To summarize. I am sending report out as a .pdf it needs to auto fill the customers email address into out look also add a bcc to a static email address and also allow to me to have a generic topic and email body for this process.

And the outlook email window should be displayed and the user will manually click send.


Email body template
I need to use template for mail body to send emails from Access via Outlook.

Templates are being created in Word, or Outlook.

How can I insert external word file contents in email body?

If using external file as template is not possible, can I locate earlier saved Outlook message in Outlook folders and forward it as template?


Advice on creating email message
I have an Access application that creates an email message to individuals, pulling in information about them and then sending it off in an email. I'm building the body of the email withHTML then using an Outlook application object to send them.

I would like to have the email message be read-only. Is there a way I can do this?


Email from Access Body displays Blank Body
Has anyone heard of this issue before? I have a database .mdb that sends out an email once a click box is selected. The email is sent out from an associate who is using 2007. If someone with office 2003 reads the email the body of the email is completely blank. If someone with office 2007 opens the email it is fine.

I am thinking this may be a reference issue. When I look in the reference window in the database (Access 2007) I am showing all the references in which I believe I need.

Visual basic for Applications
Microsoft outlook 12.0 object library
ole automation
Microsoft Activex data objects 2.1 library
Microsoft dao 3.6 Object library
microsoft scripting runtime

If I have the emails display on the senders screen using .display before sending them then the receiver with 2003 can see the body. That is my current work around but considering there are 150+ emails that go out I would love to figure this out


Add Query or Table data to email body
I have a function that creates and email in Outlook but I want to add a Top 10 list to the email body.
The data will come from a query.
This is my create email function but I have no idea how to add the query result to the body.
If any one can help thatd be great.

UserNME = "MyName" Set FSO = New FileSystemObject Subjectline = My Subject" MyBodyText = "Dear My email body Set MyOutlook = New Outlook.Application Set DB = CurrentDb() Set MyMail = MyOutlook.CreateItem(olMailItem) MyMail.To = "Email@Address" MyMail.Subject = Subjectline MyMail.Body = MyBodyText MyMail.Display Set MyMail = Nothing Set MyOutlook = Nothing Set MailList = Nothing DB.Close Set DB = Nothing DoCmd.Hourglass False


Insert the contents of the report into the body of the email
I have a MS Access project here that grabs the email address from the form and emails through Outlook, which works perfectly. What I require help with is that I would like to insert the contents of the report into the body of the email.

So basically run the report, insert the content of the report in the body of the email and send. I'm not really sure how to get the datafrom the report into the body of the email.


How can I make Outlook close when sending is complete
I am using "MyOutlook.Quit" command to close the instance of Outlook that I created but.
because the vba ruins faster than Outlook sends the email, I get the warning from Outlook about there being unsent messages in your outbox, exit without sending etc.

I there a method of quitting Outlook where it waits for Outlook to finish, other than putting a loop in to delay Access for a few seconds.


Import data from outlook email body
The goal is to mine data from the body of an email and populate table fields.

Whether it is initiated from Access or Outlook is of no concern as long as the goal is successfully accomplished. Of course if the script was initiated from Access, then the messages may or may not be open, and perhaps would work on multiple messages, but there would only be few messages (3 or 4) in a week's date range.

I have a need to create a program initiated in outlook that takes an opened message and works on that message to extract data programmatically to export it into an access database table's various fields.

The email is generated from a website. I envision the user opening the email and clicking on a button that initiates the process. At the end of the data mining operation, the script would move the email to an archive folder.


Generate Email with Excel Spreadsheet in the Body
I have somthing I know should be relatively easy to do, but I can't find it in the forums. (I found a post on HTML, but I couldn't get it to work with a spreadsheet).

Here's what I'm trying to do:

On click, I'd like an email auto-generated, (using Outlook), with some basic information from the current form copied in (which I've figured out) AND an excel spread sheet in the body of the email. The excel spreadsheet will not have any data in it, I'm using this as a check list so it will be the same for every email.

The tricky part is getting the spreadsheet in the BODY of the email instead of an attachment.

Any help would be much appreciated, please let me know if I can clarify anything. Thank you for the


Email report as body of email
I want the user to click a button (on the form) that generates an html report and sends an email, through Outlook 2010, with that report being the body of the email not as an attachment.

I'm looking to accomplish this through VBA and I have tried everything that I can think of and still am unable to get it to work.


Automate *.pdf (multiple reports) to send from Access thru MS Outlook
I am trying to automate sending daily reports to a select list of internal employees, and Access 2007 is only letting me send one at a time, not multiple reports in a single email.

Not only do I have this problem, but, each time I try to send one usingthe macro function (this is one report for one email) MS Outlook asks me to accept/deny this priviledge. How do I get around this, so that I can automate the sending of multiple reports, and override the security of MS Outlook that forces me to accept/deny sending the email? My boss would like me to send out the reports on his behalf as if it is from his email box? Can this be done


from a db, send one email to multiple people
I have code in my access db that selects certain email addresses from a table, opens outlook and sends them an email. I can't figure out how to add multiple email adresses to one email. any help is appreciated:

' Now, we open Outlook for our own device.
Set MyOutlook = New Outlook.Application

' Set up the database and query connections

Set db = CurrentDb()
mysql3 = "SELECT [User_Email] From [User_Data] Where [Access Level] =" & 4
Set rsemail = db.OpenRecordset(mysql3)
' this is where we loop through our list of addresses,
' adding them to e-mails and sending them.

'Do Until rsemail.EOF

' This creates the e-mail

Set MyMail = MyOutlook.CreateItem(olMailItem)

Do Until rsemail.EOF
' This addresses it

MyMail.To = rsemail(0) 'maillist("email")

'This gives it a subject
MyMail.Subject = Subjectline$

'This gives it the body
MyMail.Body = MyBodyText
MyMail.Display

'And on to the next one.
rsemail.MoveNext

Loop

'Cleanup after ourselves


Attachments
I have created a function which creates emails for various staff. The emails contain three attached files which initially appear in the body of the email. I have selected the Display option so that I can review the emails before sending.

So I click the Options and Plain Text on the Outlook Toolbar so that the files are transferred to the top of the email in the Attachments box.
I would like to know if I can use code so that I do not have to perform these manual steps to move the files befor sending the emails as I have a lot of emails to adjust?


sending emails
I have a problem with sending emails. I have hyper-link field called email in my database and I would like to send email to email address after I click on the button. Here is the code I use:

Dim email As String Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem email = Me.email Set objOutlook = CreateObject("Outlook.application") Set objEmail = objOutlook.CreateItem(olMailItem) With objEmail
.To = email
.display
.send End With
objOutlook.Quit Set objEmail = Nothing

But it loads not just the email address but also the displayed text. So it looks like this:
To: marta#mailto:email@mysite.com#
And I can't send it this way. How can I solve this problem


FORMATTING Outlook Email in BODY of Access code
I have a button on my form that opens out an outlook email. Ont his part of the code:

With oMail
.To = Left$(strEMail, Len(strEMail) - 1) 'Remove Trailing ;
'.Body =

is where I enter what I want the message to display, however I cant get the formatting right. Im using access 97. ive attached a word doc which shows EXACTLY how id like the email to open up with. can anyone help me make it look like that


FORMATTING Outlook Email in BODY of Access code
I have a button on my form that opens out an outlook email.

With oMail
.To = Left$(strEMail, Len(strEMail) - 1) 'Remove Trailing ;
'.Body =

is where I enter what I want the message to display, however I can't get the formatting right. I'm using access 97. I've attached a word doc which shows EXACTLY how id like the email to open up with.


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.


Previewing a email before sending
I use the code below to automatically send an email when the user presses a button on my form. They now want to preview the email and then hit send in outlook. I know .send is the command for auto sending but what would I use the have them preview the email first?