Send Mail Automateclly

Feb 19, 2006

I send mail massage with the code
DoCmd.SendObject , , , strToField, , , strSubject, strMessage, False


and the access ask me the file attach

how can I send automateclly with no msgbox

View Replies


ADVERTISEMENT

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

Only Send A Specific Record Via E-mail

May 13, 2005

I am trying to use the cmd.sendobject to send an e-mail to a specific e-mail address after clicking on a button on a form.

This works fine but send all the records within a form or report but I would only like to send a specific record not all of them.

The form is a continuous form.

Many thank in advance!.

View 2 Replies View Related

Send Mail Merge With Attachment

Sep 20, 2006

I have been searching the forums about how to send an email using a mail merge Word document with attachments and have not found a way to accomplish this. There are numerous posts on haw to send email using the SendObject function with attachments but I really need to use a Word mail merge to satisfy the requirements set forth by my superiors.

The database uses a query to pull the list of recipients. The query contains the name, email address and a few other informational items that need to be put in mail merge. I also need to attach a second 5 page Word document. At this point, I don’t care if I have to deal with the Outlook security or not, I only have about 20 a day to send but if there is a way to get around it, that would be cool.

Would it be possible to create a Report that looks the same as the mail merge document and send it to each of the recipients from the query and attach the document to that email?

I am running up against a deadline that is fast approaching and any help would be greatly appreciated.:(

View 1 Replies View Related

Can't Send This E-mail Message Error

Oct 11, 2006

I've got one of my users which has just started getting the "Can't send this e-mail message" error. Found reference to it being trying to send an email without editing (MS article 884998. My editmessage is set to yes so I know it is not this exact problem but just wondering if anyone else had has this type of issue before and could they get around it?

I tried searching but with such common words it wouldn't return any results.

View 3 Replies View Related

Send 'Report' To Mail Recipient

Aug 18, 2004

I am trying to send an MS Access 'report' as an attachment to a mail recipient in rtf format without success. Everything seems to work fine except the 'send' button. Click away and nothing happens.... no error messages, no nothing. Any suggestions or tips on how to make this work?

Thanks...

View 2 Replies View Related

Send Report From Access In A Body Of An E-mail

Dec 13, 2006

Could you please help me and advise if it's possible to send report from MS Access by mail - having report as a content of an e-mail instead of attachement?

View 2 Replies View Related

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

Send E-mail To Supplier Using Supplier Field

Feb 29, 2008

hi,

at present i have an order form. this form has a id number and supplier field . at the moment a macro runs a report which produces the order. the macro does ask me for the order number. the order number is the id number, what i would like to do is get a macro that looks at the id field and supplier field, fetch the e-mail address from the supplier table and send the order to the e-mail address

thanks
steve

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







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