Topics Search

sending data into an email body - outlook

sending data into an email body - outlook
Views: 63
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:

More topics

 

sending data into an email body - outlook

Preview
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
 

Variable Email of a Report

Preview
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.
 

Access 2010 - Sending emial (VBA or Macro)

Preview
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"
 

Email body template

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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.