Form>Snapshot>Email (AC97)

Jan 10, 2006

First off, hello to everyone here. I have been using these forums for a couple of months now and they have helped me solve many, many problems.

I've not needed to register before now because everything I needed to find out I was able to find an answer for, so THANK YOU:)

Anyways, back to business............................

I've built a reporting application where the users basically enter details on a form that performs a few lookups to autofill some info and they input the rest.

What happens next is when they submit the 'form', it appends details to a table and sends an email with the details entered to an address specified by a populated text box on the form

One of 3rd party contractors has requested we send this info in .snp format instead of just referencing the textboxes in the body of the mail.

I have created a duplicate of the form in snapshot but cannot figure out how to do the following:

1. Reference the open form to populate the fields

2. Then attach this to the email

Any help would be greatly appreciated.......as I'm tearing my hair out (and I don't really have much left to tear out anyway)

Many thx in adv

View Replies


ADVERTISEMENT

CSV File Import To AC97

Mar 4, 2008

A curious problem, I import CSV data into an AC97 table and this has worked without any problems for years. However we have recently taken on a new member of staff and one of the fields being loaded are his initials 'SF' and this results in Import errors. I tested any other letters 'ME','MF' etc. and no problem - is 'SF' some kind of reserved word ?.
Simple solution - call him 'SEB' not 'SF', but I wondered if anybody else has come across this ?

View 2 Replies View Related

Ac97 Replacement For DateAdd()

Mar 15, 2006

Can anyone suggest a work around for the DateAdd() function. I have Access 97 and this function is not available.

View 3 Replies View Related

Queries :: VBA Code On Subform To Lookup Email Field On Table And Launch Email?

Jun 26, 2015

VBA Code to go in the on double_click event of a name field in a Subform bound to a table. The subform is just a copy of a data table and within the subform view, When the field "employee name" which contains e.g. John is double clicked, I would like access to Lookup and get John's email in the employee table under field "Email" and launch outlook application and insert it into the To field.

I assume hyperlinking the field can also achieve this similar to what excel does but I am fast learning that what is standard functionality in excel is a whole another story in Access..

View 3 Replies View Related

General :: How To Send A Single Email Message To All The Email Addresses In Query

Jun 2, 2014

I have a query (Access 2007) that contains a field named "email" (which contains email addresses, of course). I want to email everyone in the query and they are all going to receive the same message. My email to them doesn't have to be personalized and I don't need to collect data from the recipients. I don't even need a reply to the email I send.

View 12 Replies View Related

Modules & VBA :: Form Which Has Button To Email Data Out In Standard Email Message

Jan 15, 2014

I have a form which has a button to email the data out in a standard email message.

Private Sub Command60_Click()
Dim MyDb As dao.Database
Dim rsEmail As dao.Recordset
Dim sToName As String
Dim sSubject As String
Dim sMessageBody As String

[code]...

This works well enough, however, FIELDS 11 through to 16 contain the venue address. This is all we ll and good if every field of the venue address is populated. here are times when not all of the fields are populated, for instance, the address might only be 5 lines.I know I can do this using IIf statements on a report, but how can i achieve the same thing for the email.

View 6 Replies View Related

General :: Send A Specific Email From Outlook To All Email Addresses Within A Query

Jan 21, 2014

I have a database that I can use to create a query, grouping companies by city. I then want to send a specific email I have created in outlook to all of the email addresses in the query.I do not need to include names.

View 6 Replies View Related

Modules & VBA :: Generate Multiple Email Messages To Different Email Addresses

Jul 16, 2014

I have made a query with the name "Confirmation" and it is setup like this:

Name trainee Email Training
John John@mail.com Tr one
Mary Mary@mail.com Tr two

I also made a button in a report with the title "Send Mail" now is my goal that if i press that button automatically multiple e-mail message's will be generated with data from people in that query. So if click on that "Send Email" button i want two different mails messages generated that will be send to John@mail.com and Mary@mail.com with in the mail body their data.

View 13 Replies View Related

Modules & VBA :: Specifying Email Address When Sending Email Via SMTP

Jan 19, 2015

I am currently using vb code to send an email in Access on the click of a button. I want the database user to be able to enter the recipient in a text box [ToEmail] which is on form [GroupStockProfiler]. However, I'm unsure how to put this into my code. I currently have the following which doesn't work (unless I put a specific email after 'To'):

Private Sub Command414_Click()
Const cdoSendUsingPickup = 1
Const cdoSendUsingPort = 2
Const cdoAnonymous = 0

[code]...

View 1 Replies View Related

Forms :: Add Senders Email Address To Body Of Email

Sep 16, 2013

I want to automate an email to include the senders email addres with some text in the body of the email.

Code:
Private Sub send_mail_Click()
Dim olApp As Object
Dim objMail As Object
On Error Resume Next 'Keep going if there is an error
Set olApp = GetObject(, "Outlook.Application") 'See if Outlook is open

[Code] ....

View 3 Replies View Related

Exporting Email Addresses To Email Program

Sep 22, 2005

I have an Access database list of people, which includes their email addresses. I want to export the email addresses to Hotmail or Netscape email.

How can I do that?

View 1 Replies View Related

Modules & VBA :: Add CC Email Addresses Into Automated Email?

Aug 3, 2015

I have an automated email system (Lotus Notes) in a Access database I have created and am looking for the code needed to add up to 3 c.c addresses into an email prior to sending automatically.

The code I have to send the email to the To: individual is all working but what code I need to add and where for the c.c addresses of which there could be 1, 2 or 3. The control for To address is EmailTo = CustCopyEmail The controls for the 3 c.c emails are cc_EmailAddress, cc_EmailAddress1 and cc_EmailAddress2.

Here's the code I have:

Private Sub SEND_CC_Click()
' Set up the objects required for Automation into Lotus Notes.
Dim Maildb As Object 'The mail database.
Dim Session As Object 'The Lotus Notes session.
Dim MailDoc As Object 'The mail document itself.
Dim UserName As String 'The current users Lotus Notes name.

[code]....

View 8 Replies View Related

DB And Email

Jun 11, 2005

I have a Access database with a field that lists emails. What I want to do is somehow tie it to my outlook so that I can email all of the people in that list. Does anyone know how to accomplish this?


Thanks.

I have Access 97 and outlook 2000.

View 1 Replies View Related

Email

May 2, 2006

Hi,

Here is a good one thats got me stuck for ages.

I have made an email facility in my database and I have set the message box as a memo for the Unlimited Characters. There are a number of templates that the user can select but I cannot get the simple text to show formatting (as in rich text style). I have had a look at RTF syntax but cannot work out how to tag the simple text to show it once it has been emailed.

Can any one help?

thanks

View 1 Replies View Related

Email

May 24, 2007

I have been workign with this email piece and am sort of close but not close at the same time....

WHat I want to do is click a button on a form and have it open up my email and force emial addresses in the "To:" section of the email...

I can accomplish this with:

Dim stDocName As String
stDocName = "Mass_Mailing_Report1"
DoCmd.SendObject acReport, stDocName, acFormatTXT, "EMAIL ADDRESS", , , "SUBJECT LINE", , True

But that requires me to maunally update the email addresses each time a user changes or is added...
What I want to do is read a table and grab the address from a field in that table. So as the table grows, changes, shrink the email portion is seemless.
Does anyone have an ideas as to how I can accomplish this?

Thanks....

View 7 Replies View Related

Email Failure

Jun 15, 2005

have a DB which is working fine on most PCs (approx 15 users) I do however have a problem sending emails from some machines (using a macro to do the send object as example below) The mail program used is Outlook 2000 / 2003

DoCmd.SendObject acReport, "Returns Notice", "SnapshotFormat(*.snp)", "to a defind list", True, ""
This works fine BUT on most machines but on a couple we get a fail message when attempting to send, this message is unspecific. I cannot find any different settings on the machines in question, the op system is 2000 / XP.

I operate the same program on my PC running XP prof servpk 2 and although 99% of the time the emails go through without issue I do sometimes have the same problem. Re-booting does not resolve it! and I can find no trend as to why I have the problem.
Any thought or advise welcome.

View 2 Replies View Related

Sending Email

Nov 30, 2005

I am useing DoCmd.SendObject to send emails - however I get outlook opening an email with my To, BCC fields filled in , however I am stuck in the new email screen - ie can't get to a previuos email to copy and paste text - like it is dialog?

Is there any way around this.

Thanks Paul

View 4 Replies View Related

Question About Email

Mar 21, 2006

Hello,
I would like to send e-mails with a customized letter paper that i want to place as background in the e-mail body. I have created a htm file (Logo + Enterprise header) , if i insert the file manualy with Outlook when when creating a message that works, i tried to
place my file + path in the last parameter of the SendObject command, when i execute i have no error but the paper is not inserted in the mail.
Just i want to do is to have the logo + name + adress etc... then place my body content under this header.
Can someone tell me what's wrong or another way to do that.
Thanks in advance.
Vincent

Command i used:

DoCmd.SendObject acSendNoObject, , acFormatHTML, rs!Email, , , gObjMes, gTxtMes, false,"C:.....MyLetterPAper.htm"

View 7 Replies View Related

Email With Access

Mar 26, 2006

I just want to click on an email in my forms folder and have outlook open up with the recipients name in the to: field any help will be appreciated.

Thanks

chris

View 2 Replies View Related

Email Merge

Aug 20, 2006

Hi,

I have been searching for related posts to this question; however, there either were not any posts that answer it or I can't find any.

Basically, I need to do something exactly similar to mail merge, but with email. Is that possible in Access?

Any help will be very much appreciated.
B

View 3 Replies View Related

Auto Email

Oct 30, 2006

Can someone please look at this and help me as it does not work? It stops right away at the "Dim olApp As Outlook.Application". It tells me "user-defined type not defined". I have searched the forums and could not find a solution.

Thanks,
RichB



Private Sub Command154_Click()
Dim olApp As Outlook.Application
Dim objMail As Outlook.MailItem
Set olApp = Outlook.Application

'Create e-mail item
Set objMail = olApp.CreateItem(olMailItem)
With objMail
'Set body format to HTML
.To = "Forms!FrmPersonal!Email"
.BCC = Forms!FrmPersonal!rateremail & Forms!FrmPersonal!rrateremail
.Subject = "AUTO EMAIL REMINDER"
.BodyFormat = olFormatHTML
.HTMLBody = "<HTML><BODY>Blah, Blah, Blah</BODY></HTML>"
.Display
End With

End Sub

View 2 Replies View Related

Help Help With Email Function

Dec 6, 2006

i'm writing a function to send an email with the option of attachements
This is the code i'm using, it works fine but i need to be able to sne mulitple attachments. What would be the best way of doing this?

Thanks

code:
Public Function SendEmail(strTo As String, strSubject As String, strBody As String, Optional strCC As String, Optional strAttached As String)
Dim olkapps As Outlook.Application
Dim olknamespaces As Outlook.Namespace
Dim objmailitems As Outlook.MailItem
Set olkapps = New Outlook.Application
Set olknamespaces = GetNamespace("MAPI")
Set objmailitems = olkapps.CreateItem(olMailItem)
With objmailitems
.To = strTo
If IsNull(strCC) = False Then
.CC = strCC
End If
.Subject = strSubject
.Body = strBody
If IsNull(strAttached) = False Then
.Attachments.Add strAttached
End If
.Send
End With
Set objmailitems = Nothing
Set olknamespaces = Nothing
Set olkapps = Nothing
End Function

View 5 Replies View Related

Breaking Down An Email

Jan 18, 2007

I want to take a report which covers sales figures and e-mail to those people that have had sales in the period. I only want each person to get just their records, not the whole report. Any ideas how I can do it automatically, starting with a query of records or a report ? ?

I know how mto e-mail a standard report using a macro !!

View 1 Replies View Related

How Do I Email The Program?

Feb 11, 2007

I am using Microsoft Developer and wish to email the program to my customer. With Developer, there are tons of files and a few folders, not just one exe. I realize I must zip to send a exe, but the folders are a problem, since WinZip, which is what I have, will not accept the folders, only files. I could ship like that but it would be a mess on my customer's end. Any suggestion would be helpful.

The reason I want to send this way is just for speed. Of course I can copy to CD and send that way.

Sharon

View 2 Replies View Related

Email Attachment

Feb 17, 2007

Hi,
I was wondering if it's at all possible to add an attachment which is a pdf file to an email? I've searched this site and can't seem to find anything on this.
Thanks
Geno

View 1 Replies View Related

Launch Email

May 22, 2007

Can I open an email to send filling in the To or the BCC field but maintain my outlook signature page???

Currently I open email, but my signiture is missing???

Thanks

View 3 Replies View Related







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