E-mail From A Form

Jun 16, 2006

Friends,

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?

Thanks,
Mike

View Replies

Mail Once Again - Opening 'new' Mail-window And Export Mail Adress

Jun 23, 2006

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

Is this possible? And how?

(BTW: I�m a newbie with VBA)

View 2 Replies View Related

General :: Bulk Mail Send With Different Mail Body Contents

Apr 26, 2013

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

View 2 Replies View Related

E-mail Form

Jan 20, 2006

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.

View 6 Replies View Related

E-mail Send Via A Form

May 12, 2005

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.

Many thanks in advance

View 5 Replies View Related

Opening A New Mail Through Hperlink On A Form

Jul 10, 2005

Hi,

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'm using MS ACCESS 2000 & WIN PRO 2000

View 4 Replies View Related

E-mail A Specific Record Through A Form

Mar 9, 2005

Hello everyone. This is my first post.

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?

View 5 Replies View Related

Reports :: Make Report The Same As Form And Sub Using Mail Merge

Jul 16, 2013

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?

View 3 Replies View Related

Can Put A Button On Form To Create Mail Merge Letter?

May 8, 2012

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?

View 1 Replies View Related

E-mail Help

Sep 26, 2006

Hi, im new to Access -

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 have searched the forums but have had no luck,

Thanks in Advance

View 3 Replies View Related

Generate E-mail

Apr 26, 2005

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.

View 1 Replies View Related

Using Cc: With Mail Merge

Jul 20, 2005

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.

View 2 Replies View Related

Mail Merge

Dec 28, 2005

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.

View 3 Replies View Related

Mail Merge

Jan 23, 2006

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?

View 2 Replies View Related

Mail Merge

Apr 12, 2006

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.

View 4 Replies View Related

Mail Merge

Apr 2, 2007

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.

Thanks in advance

View 4 Replies View Related

E-mail Issue

Jun 2, 2007

Hi,

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

Any suggestions?

mafhobb

View 3 Replies View Related

E-mail Validation

Nov 15, 2007

Is there any way i can mask an e-mail field to require an @ symbol?

oh and is there any way to put some kind of letter prefix on a AutoNumber field?

Cheers

View 2 Replies View Related

Mail Merge Help!!

Feb 15, 2007

Hi,

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!

Chris

View 1 Replies View Related

Image In An E-mail

Apr 27, 2005

Hi

i have a form, with a command button, which when you press it automatically sends an e-mail

At the moment, that e-mail is just text. What I want is to insert the company image in the e-mail?

Have tried doing this but keep getting error message (put image on the form and then referenced Me.logo behind the code)

Anyone know if this is possible

Chris

View 3 Replies View Related

E-mail Attachment?

Aug 22, 2005

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?

Thanks.

View 3 Replies View Related

E-Mail Data

Feb 3, 2006

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 ?

View 2 Replies View Related

E-Mail Alert

Sep 30, 2004

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?

View 4 Replies View Related

Mail Merge - Please Help!

Oct 20, 2004

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.

I hope that makes some sense.

PLEASE HELP!

-Preston

View 3 Replies View Related

Using Cc: With Mail Merge

Jul 20, 2005

View 6 Replies View Related

E-mail Lists

Apr 4, 2006

Hi, help please!

I have an access database with one column containing e-mail addresses.

How can I use them to easily send out multiple emails from this database?

If I copy and paste, the whole columns/cells are copied, but to copy them individually is clearly very time consuming.

All I need to do is somehow get them to a format that I can paste them into my e-mail address box.

Am I being thick or is this option not available?

Richdv

View 1 Replies View Related