Simple E-mail Problem

May 2, 2005

Hi!

I have a query in my dtabase that produces different e-mail addresses every day.

I want to add a button in my form to send a simple message to everyone. The message is the same for all.

Any ideas how to do that?

View Replies


ADVERTISEMENT

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

Simple Question For A Simple DB

Dec 29, 2006

Ok I am right now making a simple Vendor/Product database to create a line sheet for some sales folks. I have 3 tables: Vendors, Products, and an associate entity Vendors_Products to relate the two. I have a form currently that draws the Vendor Name (primary key) from the Vendor table and the Product Name from the associate entity. This allows me to create new vendors and select current product types from a drop down box. The problem is that the drop down box is too long and it is tiresome when 1 vendor has 10 product types.

Can anyone tell me how to resolve this? I thought it would be better to have option buttons and display all available products. Then you could just click all of the option buttons that apply to that Vendor and it would create the relationships...is this possible?

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

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

Mail Merge

Jan 17, 2008

Im after a bit of advice really. Im looking at building a mail merge facility, i already have one example where you have to select the letter you want to merge the data to.

The problem i have with this at the moment is i have allot of letters that are all basically very similar and the user might pic the wrong one, each letter is slight different and runs by a contract name.

Is there a way that the user can just select the type of letter they want, then select teh contract and then when they click the mail merge button access will know which letter to open.

Just looking for possible ways or examples.

Thanks

View 5 Replies View Related

Mail Merge Question...

Jul 1, 2005

I'd like to set up a mail merge that pulls information from individual records. For example... If I want to do a pre-formated Fax Cover Sheet in Word, and fill the information in with the mail merge.

I don't want this to pull information from all of the records. I want to choose which record to pull the information from. First of all, can this be done? If so, can someone help me out with this? I have no idea where to even begin with this one. I have several mail merge documents set up right now that pull information from queries, but this is something that I'd like to do that is completely different.

Thanks in advance for any help that you can give.

View 3 Replies View Related

Mail Merge Questions

Aug 31, 2005

What is the advantage of using mail merge?
It has been suggested to me that i use mail merge in the current application that im building. This is mainly because my client needs to send a lot of custom letters that will be different each time one is sent.
From what i know about mail merge you can only display information in a document in a flat format ie u couldnt have customer details at the top and then a table of all the orders/ transactions they have carried out below? is this correct?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved