I'm trying to create a button who is able to send a email with an attachment.The attachment will be all the time the same file.The email address to sent to is one of the field of the database.I need a copy sent in my email address as well.
View RepliesI would like to create a database that would enable me to select various options (from dropdown lists) which I could then have tidily arranged in an email that would automatically be sent to the recipient.
Before I attempt to design the facing page I'd like to know if this is an option in Access?
After inputting data into a text box on a form i want to click on a command button which will open an email program and then put the text there so i can send it.
View 1 Replies View RelatedI have a form that records data entered by a user who I then want to email the record via a report run from a query.
I created a command button on the form with DoCmd.SendObject acSendReport,"name_of_report", "format", "to","subject", False
The email program (Lotus Notes) opens a new email msg with the report attached as pdf. However, the data recorded does not appear.
putting a search button on a form on my database.
On the navigation buttons at the base of the form there is a search facility where I can type a record id but I would like to get rid of that and search records either by turning the ID field into a searchable box or by adding a button where I can press it and get a search box up.
I am sending an email using SendObject. Sometimes it works, and sometimes it makes the computer freeze up with no error message. I have tried this with Outlook running or not running, seems to make no difference.
Code:
'The sub procedure below sends e-mail in response to a click on the Send button.
Private Sub SendMessagesButton_Click()
'For Access, define some object variables and make connections.
Dim myConnection As ADODB.Connection
Set myConnection = CurrentProject.Connection
Dim myRecordSet As New ADODB.Recordset
myRecordSet.ActiveConnection = myConnection
[Code] ....
I have added some MsgBox () to narrow down where it crashes. It is after 'Five' and Before 'Six'. On the line:
Set appOutlookRecip = .Recipients.Add(eMailAddress)
I am mystified as to why it works OK sometimes, and not others. The email address being used is valid.
I've created a simple database, with tables, forms etc but I've got stuck when I've tried to insert a 'Button' onto the HOME page which when pressed will display an invoice and give you the option of emailing to client or printing.
I think I've gotten messed up in my relationships or the macros which I've copied from another access template.
on the home screen, I click 'new quote' then 'view quote' when the window pops up and then when it tries to generate the invoice I get the error
'an action query cannot be used as a row source'.
I've put a copy of the database in my dropbox...
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.
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 RelatedI 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 RelatedI am creating a database for creating quotations. The quotation number is generated using the date, for example the first quote today would be quote number "05202015-1" because it is the first one today. The next quote today would be quote number "05202015-2" and so on. Is there a way to make access automatically generate these quote numbers based on the date?
View 3 Replies View RelatedI searched the forums, I downloaded sample datbases EmailA2K, example, and PrintCurrentRecord_Update however I cannot get my command button to fill the TO: with my customer email address. I have gotten lost in the code so I went with a send object macro. Maybe it's my internet service. I use Compu Serv which is a by-product of AOL. Can that be the problem? Anyway I don't understand code, I wish I did. I select send object as my action in my macro. I leave the object type and object name blank as well as the output format. In the To: I put = [email address]. In the subject I put "From CG" and the Edit Message is set as "no". When I click on the button it opens up my email provider but nothing is in the To:. I first tried to fill in the Object name and type and format and it attached the records in the form, I DO NOt want to do that. All I want is to have the Email Address be filled in the To: by clicking a button. I'm about 8 hours on this and a little on edge. I would like to get a good nights rest and not think asbout this anymore. Any Macro help would be great.
View 2 Replies View RelatedHello all:
Right now, I have a contact database with email addresses, and would like to know if anyone has any suggestions on how to implement a command button that when I click on it, it will do the action as clicking on a link that says
mailto:anyone@anyone.com
If I type the mailto: before the email address, and click on it, it will open the email message window, but I am looking for a way to have the user click on a button and then it opens the email message window.
My field for the email is fldEmail
any suggestions?
~~Bradley
I have set up a work order database. On the Work Order Submission form I have
a command button that adds the record to the table. I also have a button to
email the Submission Report. When the user fills out the form and clicks the
Add button the record is added to the table. The user then has to scroll to
have the record reappear in the form and then click the Email command button.
This works fine but I want to make this a one click operation.
I have a filter on the report that will be emailed to limit the report to just the current
record. The filter is:
[ID] = Forms![WO Submission]![ID]
where ID is the Primary Key for that record. If the record has not yet been
added to the table and thus has no primary key, the report to be emailed
will contain no record info.
I'm thinking I may have to use a temporary table but I'm clueless about how
to make that work.
Any suggestions?
1:is it possible to have a clickable button beside each record in the report format that when clicked runs another report and inputs data into parameter querys automatically that the second report asks for? Etc. the second report will ask for [Username], [start Date], [end date]it copies and pastes the details from the row clicked into these parameters? or get it to work in a simular way? reason being for this the details need to be in a certain format layout that then on a button click Emails the report as a PDF
2:is it possible to have a button on the report screen that will Email the report as a PDF file with only the parameter data shown?
I have a DB that holds multiple possible email responses, originally set up for just straight up create email based on this information. the Button to created the email works great. Now what I would like to be able to do is Click a 2nd button that instead of creating a new email, it would open a reply to the current opened email. I would still want to push the information to it like it does in the current new email button.
View 1 Replies View RelatedI would like to create a button that when pressed opens up an outlook email. The email address will be populated by one email address every time. I don't want it to automatically send as the body will need to be filled out by the user. It would be useful if the date and time it was sent could be recorded in the form somewhere too (would this be in a text box?).
View 3 Replies View RelatedI have a combo box with different department names in it
I have a button in a form called cmdShowDept the caption "Show only one Department"
When I open the form I have the combo box set to not be visible
When the Show only one Department command button is pressed I want the following to happen;
The Department combo box should appear
The button's text should change to "Show all Departments" in red
If the button is clicked when the text is red then:
the original button text should return in Black
the department combo should disappear
After clicking on the button and you click one of the specific departments ie accounting I want it to show only the accounting records in the form.
I'm still learning about access, so thanks for any help anyone can give me pleeeese!!
Like the title says I need a command button to print preview and email two reports. I tried using macros but the problem I have is that it'll send out two emails instead of one email with two attachments. The other problem is that it won't recognize current pages information so it'll show two blank reports. But If I go to next record and come back in form view, it reognizes the changes and the reports look fine. Any help would be appreciated.
View 2 Replies View RelatedI have created a form and housed in the form is a combo box that pulls info from managers I work with. I want to create a command button that I can click to send them an email. I have their information tabled and then have also converted that table into a form. I have their email address I just need to know how to properly code the command. I have no visual basic experience. I have had classes where I've coded in C++ and HTML but very limited.
Thanks
Hey all,
I've attached my access file...if anyone could help I would appreciate it very much!
If you click on the Export & Email tab on my form, there is a button which describes what i want to do in the caption.
Basically...
When the button is clicked i want a warning message box to appear saying do you want to continue Yes/No. No would just cancel it.
Yes would do the following:
Export an Excel file of "Magtable" and save to C:Magazine BackupMagazine Counter.xls and W:Magazine CounterMagazine Counter.xls
Then (i dont think the order of the following matters)
Email the excel file to two people.....if its easy to do this with no data input needed by the user (ie: not having to type the subject, who its too, body or press send.....if this is too complex then that is fine..having as much in as possible would be good though)
Then I want the values in Magtable, Amount to be reset to 0 - this may have to be done before the email is sent?
BTW the company i work at uses Lotus Notes only as an email program....As long as it pops up a new email in lotus notes with the excel file as an attachment then that would probablly be enough.
Hope this makes sense :S Any help would be VERY appreciated!
Thanks!
Acs
A command button on a form that can:
1- Open the Report called : ConsentForm
2- Print it to PDF printer (report is currently defaulted to that printer driver)
3- Save to folder: C:SOSConsentForms
4- Save as: Consent_[Last]_[First] (these are field names on the form)
Result i.e.: C:SOSConsentFormsConsent_Doe_John
5- Then send the file by email (Outlook) to : abc@hotmail.com
So I have created this database for a lessons learnt system. Is it possible in Access 2007 to create a button that if pressed automatically sends an email out to someone? So my main form in the database is a split form which contains a search filter, which works well and also contains a button called add new lesson. This button is linked into another form and when pressed brings up this new form. In this form it has a save and close button. What I actually would like is when the form is updated and this save and close button is pressed, an email is sent to a "project head" who has to confirms the information before the data is saved into the database. Is this actually possible?
View 1 Replies View RelatedMain form is frmPeople
As you can see i have a subform called frmPeopleInsurancesSub
Next to that I have a Edit Command button which open a forms called
PeopleInsurances
When user wants to edit one of the insurances all user has to do is click on on one of the insurance and click edit to take user to that record
But cant make it work
Any Ideas
Hello All-
I'm at the end of a long project that has one last step. I was hoping that someone here would be generous enough to help. I'm pretty much a novice at Access and am sure that my question can be easily answered. So here is the problem.
I have data that is loaded from a PDA to a form in Access. The data can then be viewed in a list box which is great. I also need to be able to save the data from the list box, using a button, as an excel spreadsheet. Is there anyone here that is willing to guide me to a solution?? Thanks in advance -Tom
Dear All:
I have created a from which contains names, address, ID's and other data.
I wish to place a command button on the form and when it is pressed, a page pops up with instructions on how to use the database.
Any ideas on how to get started?
Thanking in advance,
Dion