I got the e-mail code from
http://www.access-programmers.co.uk/forums/showthread.php?t=100584
but I cant seem to implement it. into what I am trying to do. I am trying to make a form that has the names of bunch of people, then in the form I can select multiple people and send them an e-mail, and preferrable type a message that will then when I click send will transfer to outlok from which I just press send putton. well in other to have the same function as outlook express but in access.
Hi, this is probably a very easy question for you “Access-gods” out there.
I’ve made a database (MS Access 2000) with all my clients. I collect a lot of contact info, including e-mail.
I want to make a function which opens a new mail window (Outlook 2003) and automatically puts in the e-mail from my form (In the send-to field of outlook).
I have a ms access table with two fields...tablename is ..."Addresses"..
Field1:= Employee_mail_id Field2:= Leave_balance
What I need to do is that,I need to send individual mail (in Bulk) two each employee intimating their leave balances. Is it possible to do it in vb .I want it to assign the codes in a button.
Below iss the code.
Dim r As Recordset Dim email As String Set r = CurrentDb.OpenRecordset("select * from Addresses") Do While Not r.EOF email = email & r(2) & ";" r.MoveNext Loop r.Close DoCmd.SendObject acSendNoObject, Null, Null, email, Null, Null, "Test subject", "Message body of the test letter", False, Null
I know that this topic has appeared in one form or another throughout the Forums. However, not being a code expert, I would like some "in my case" help.
I am wanting to create a button/etc that will create an email with the following:
1. addressed to joeschmo@his-mailaddress.com (this same person will always be receiving the e-mail we want to send.)
2) The subject line should be "Database Correction Request"
3) The body should say: "Dear Joe, I am requesting that there be a change to the database for (FirstName & LastName field from the current form). LineReturn LineReturn LineReturn Thanks, Mike"
What code do I use and how can I "program" this to work when I click a button or link?
I would like to have a button on a form, against each record that has been entered onto the form and once the button has been clicked on, an e-mail would be automatically be generated with the contents of particular fields and automatically sent to a pre designated e-mail address.
Is this possible, if so and help would be most appreciated.
I'm very new to this database game and have just starting creating a customer information database. But have come across a problem already. I created a form which I've setup a field which contains customer email address, when click on it the hperlink, it trys to find a web site....
"Unable to find http://abc@abc.com. The internet site reports that the item you requested could not be found (HTTP//1.0 404)"
But what I want it to hyperlink it to is MS Outlook 2000. Can any help?
I need help on figuring out how to e-mail a specific record from a table through a form. What I have is a table that houses information that some of my call specialists populate as they are speaking with the customer. What I want to happen is when they hit the control button "E-mail this call" it pops up with an e-mail and asks for recipient. So far I got it to do this with entire tables/forms/queries/reports; It imports it into an excel spreadsheet and attaches it to an e-mail, which is cool. But, what I need to happen is that it only takes the specific Record that they entered and email it on.
I am pulling my hair out there trying to figure out how to do this. Any ideas?
I am using mail merge to add info from my database to my word document template. I want to make it the same as my form I have set up which gives me a patient name, dob, GP details as head of main form then a subform (continuous) of their medication. When I try a mail merge it comes up right but only shows one medication on each page. I want it to add all their medications to the body and have the patient info in the heading. Do-able?
I have a database for my business, which lists clients details. Within this, I have a query that runs off receipts (one customer, many receipts), as I run a private school and people pay me monthly. I use this query to run off a Mail Merge letter within Word, but it's difficult, having to close the db and open a Word document and then relink it.
Is there any way that some coding could be used within the db so that I can add a button and just print out that record into a mail merge document?
Anyway, i have a table with two fields - Email, and Verify Email, how do i do it so the user has to type the correct Email twice or an error message will pop up?
I've searched the site and haven't really come up with an answer for this. I have a Report that I want e-mailed to two people every 10 days. If someone could give me a direction to start in, it would be appreciated.
When applicable, I have letters in Word already set up to show the cc: information at the bottom. However, Management needs a statement added to the bottom of the letters that ONLY show the cc:
I am having a slight problem trying to figure out how to make this statement show up only on certain letters.
Does anyone have any thoughts that could help me? I'd appreciate it very much.
I am totally new to Access and this is my first database.
I have a database for volunteers in which table A is basically a calendar and table B a list of volunteers with their details.
What I want to do is construct a report that will allow me to produce a mail merge letter such that:
1. One volunteer, with his/her information, is selected from table B and inserted into a mail merge letter. (The volunteer selected will change from letter to letter).
2 Certain days are selected from table A and added to the mail merge letter. This information will be the same in all letter.
I have posted a separate thread asking how I can make the selection of days in (2) above so you can assume that I know how to make the selection within table B.
How do I proceed?
If anyone knows a good example of this type of report then i will be extremely grateful.
I have a table that has, among others, Address1, Address2 and Address3. If Address2 andor Address3 are empty for a particular record, I get blank lines in the Word doc. How do I prevent these blank lines?
Hi, i have set up a mail merge between a query and a word document. My system is a system that processes transactions from an online cd shop. I have made it so that each cd that is bought by each customer is a different transaction in a transaction table, and each transaction is given an order number to group them. How do i get the mail merge to show all the transactions in an order on the invoice in my word doc because at the moment, even if i add two of the title name fields, they both show the same transaction.
Anyone have a good online resource for generating a single thank you letter, eg. by way of a mail merge using MS Access 2003 with Word 2003? I know you need to write a form letter first with various fields that conincide with fields in Access. I have done this many times with large mailings but need to know how to write individual letters for thank yous, invites, etc.
I am trying to create an e-mail link in my "about" tab. All I need is a piece of text "me@myemail.com" that any user can click (it could be a button too). Clicking on the text (or button) would open the e-mail program with my address in the "To" field and "Question about the database" in the subject line. The user would then be able to type the email and send it.
All of us use the Novell Groupwise e-mail program.
This has to be simple, but scanning through the other threads, I get horribly confused because it appears than many lines of code have to be written and I am no code expert. There has to be an easier way of doing this....
I am editing the design of a census, and I would like to be able to mail merge form the query directly to a new document in microsoft word...so you can create the document and then merge to it, is this possible using a macro or VBA? I can't work out how to do it!! The query name is "List of Families" and I want to merge to a blank document, so I can create a different document everytime...as the letters aren't circulars!
Is it possible to attach an email in a field of a form?
We have a database that keeps track of technical orders. We get e-mails on what we are supposed to implement on a particular tech. order. Is there anyway I can attach or make a copy of this email or something to have it in a field of my form?
Hi I have set up some automated e-mail, My problem now is that when i bring up outlook to send email, I want the users to be able to put their business contacts on there from their address book. Meaning my program does not controll the TO, CC, or BCC...
HOWEVER! I need to create a log of these fields, amongst other things whenever a user emails from my application. IS it possible to pull information like that back off of outlook when they send the email ? or am I SOL ?
My knowledge of access is pretty limited. Can anyone help me with this problem. I have some due dates entered into the database via a form. Is it possible to send an email alert say 1 month and then 1 week before the due date?
I just finished creating an access file. Here are the contents:
TABLE Customers - Includes email, contact name, company name, address, zip, city, etc. TABLE Materials - Includes company name and material. Each record is listed as a company with a material requested. Companies are listed multiple times, as they are unique records because the materials are different.
I have Company name set up as the primary key, and it sets the relationship between the two tables
I have a Report fully working. The first page is a letter with the customers' mailing info at the top. The second page is a list of all the materials this company ordered for the 2004 year.
The report pulls from a QUERY that comes from the customers table and the materials table.
This report is hundreds of pages long, as we have multiple customers who order many materials each.
My question is "How do I mail merge this report out to the customer?" I do not want to send each customer the whole 500 page report, but only their specific record that they should receive.
I do not care if I have to merge with Word, Outlook, etc. I just dont want to have to send these out individually.
When applicable, I have letters in Word already set up to show the cc: information at the bottom. However, Management needs a statement added to the bottom of the letters that ONLY show the cc:
I am having a slight problem trying to figure out how to make this statement show up only on certain letters.
Does anyone have any thoughts that could help me? I'd appreciate it very much.
