Sending Email Containing A Link To Access?

Aug 6, 2014

I have a system automated that, when our warranty team receives a warranty part that somebody else has requested information for, will email that person letting them know it has been received.

I want to include a hyperlink in the email that points to the database, opens it with 2 argument containing 2 variables in which one of the forms can auto populate and the information be shown immediately.

So first, I would like to know how to create a hyperlink within the code that sends the email. Second, I would like to know how have the database check for arguments upon opening. I can do the rest.

For instance, John Smith requested part number 123456 on claim number 55555, serial number 7777777. The database is located at "S:SharedWarranty ReturnsWarranty Returns.accdb". Therefore, the hyperlink would aim at the location and carry the arguments 55555 and 7777777.

Current emailing code (obviously variables are passed into the function):

Code:

Function sendemail(msg As String, subj As String, recipients As String, ccrecipients As String, xclaim As Integer, claims() As Variant, serials() As Variant)Dim rsnote As Recordset
Set cdomsg = CreateObject("CDO.message")
If recipients <> "" Then
With cdomsg.Configuration.Fields

[code]....

View Replies


ADVERTISEMENT

Sending An Email From Access

Jul 19, 2005

I'm sending an email from a form to Outlook express. But before it opens Outlook I get a question that states "a program is trying to access email address you have stored in Outlook" I then have to click ok and then another window opens and askes the same question. How can I eliminate these warning messages??
Thank You

View 4 Replies View Related

Sending And Recieving Email Through Access

Aug 11, 2005

Is there a way to send an email using outlook, have that email filtered into a specific folder, and then have an access program extract that email. The situation is that I have sales reps in the field that would like updates on projects that are stored in an access program I designed. The program already sends out auto notifications through outlook, but that is only when I update the specific project. All of the sales reps in the field use blackberry's and do not have time to call in to request an update. So I was wondering if it were possible to have a sales rep send a preformated email that has included the primary key ie Account number, and have access recieve that account number to turn around and send out an auto response.

View 6 Replies View Related

Access- Sending Email With No Outlook Profile

Feb 6, 2006

Hi all,

after spending wweks perfecting a database which centres on the ability to email the contents of what you have just entered i find that our stirling IT dept haven't actually setup any of my intended users with outlook profiles and do not intend to. Therefore whenever they try and send an email they get the dialog box you get when trying to connect to the internet for the first time. Which is obviously a problem.

Is there any way around this or is there any alterntive i can use? my IT dept dont promise to setup any outlook profiles soon and im hoping there may be something else i can do before the project gets binned.

cheers

greg

View 14 Replies View Related

Newbie Question - Sending Email From Access

Mar 10, 2007

Hi,

I have a request from work to create a button that will allow only certain fields from a record, ie tracking number, to be sent to that client's email in the record by adding a button to the form that will automatically send the field.

Can someone help me?
Thanks.
Trevor.

View 4 Replies View Related

Modules & VBA :: Sending Email With Access 2007

Mar 12, 2014

How would I set up an Outlook email using a list of recipients from an Access table? I'd like to be able to run this from Access 2007 and not Outlook. However, once the email is set up, I'd like to be able to go into the email and add subject, body, etc. before sending the email.

View 5 Replies View Related

Modules & VBA :: Sending Email From MS Access 2010

Oct 1, 2013

I would like to update the following code I have been using to send emails, from Access 2010 via Outlook 2010, to include my signature block with hard returns in between each line and a few above the signature.

Lets say the signature would be:
My Name
My Company Name
My phone number
My Reference

I tried next to: stMessage = Me![EmailMessage] &"My Name" & Chr(10) & Chr(13) & "My Company Name"

etc.

It does not work..

Here is the coding :

Code:
Private Sub SendEmail_Click()
On Error GoTo ProcErr
Dim stLinkCriteria As String

[Code]....

View 5 Replies View Related

General :: Access 2003 Is Not Sending Email?

Feb 3, 2015

Our database is in access 2003. It has a form which has a button to send email of orders. I added a new user in this database. That button works in all other computers in the network with the same user permissions as this user, in his computer when he select to email Order it does nothing. It does not open the new email page in outlook and the outlook email is configured in his computer.

View 3 Replies View Related

Access Sending Automated Email Attachments

Mar 6, 2012

I have inheirited an access database which used to mail out an attachment automatically but for some reason has stopped sending.

View 1 Replies View Related

Modules & VBA :: Sending Digital Secure Email In Access

Sep 4, 2013

I have a question about sending secure emails by VBA code in MS-Access. I have a Access application within you also can also send emails by VBA code using outlook. Everything works fine, but now the recipient wants to receive the mails with a digital signature by S/MIME.

I got a digital certificate from the recipient as a pfx-file.

Is this possible in Access using outlook ?

I use MS-Access 2010 en Windows 7

View 3 Replies View Related

General :: Sending Form Through Email And Processing Responses - Access 2010

Oct 16, 2012

I'm working on a vacation/time off tracker and was hoping to use the collect data feature. I've created a form where a user submits their requested date and number of hours, at which point I'd like the form to be sent to their manager for approval. The manager's email address is stored in a table. Once the manager marks yes or no, I'd like that reflected in the time off requests table, and an email sent to the requester letting them know if it was approved or not. Is this possible? How would I go about it. I'm pretty new to Access, learning on the fly, but I'm pretty good at modifying code to match my situation/working backwards if you have any examples for me to look at.

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

How Do I Link Email Text To An Access Database?

Feb 3, 2006

I'm creating a contacts database in Access. My emails are saved on Novel's GroupWise (web-based, not a client application). My database is on my hard drive and contains the usual: name, address, preferences, etc.

Is there some way to link the actual text of a customer's email to the entry in my database that deals with that customer (for example, field 1= name, field 2= phone number, field 3= actual text of email)? If the web source is a problem, would there be a way to do it if I imported the emails to Outlook or Outlook express?

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

Sending Email!

Jul 14, 2005

Hi!

I got a question about emailing.... I don't think this is possible but I thought why not ask....

Is it possible to have a button on a form, that when it's pushed, it sends an email with a report included to a certain email adress?

thanks!

-jake

View 11 Replies View Related

Sending Email

Apr 27, 2006

I have been able to create a form that will send an email automatically when the form is opened. Tha problem is, the email will not actually send until I open Outlook. Any ideas?

Thanks in advance.

View 14 Replies View Related

Sending Email

Feb 8, 2007

I am looking to write some code that "OnSave" in a form will run some code

No worries about writing the code on an event, I will figure that out...

What I want to do is:

If txt box A is not null then send an email to some recipient.

QUESTION:
Does anyone have an example of code that will send an email to someone from Inside Access.

View 3 Replies View Related

Sending Email From Form

Apr 25, 2005

Hi guys,

i want to send an email to several people when someone else enters a complaint in my database.
I have a form which displays the complaint with a reference number, recordsource is "tblKlachten". i have query that is set to return only those emails i want it to send to called "qerMailBeheerder". In there is a field called "email".

Now, whenever i a user closes the form after adding a complaint, i want at the same time a mail sent to those ppl in the query with the subject the reference number of the complaint (field called "Referentienummer") and in the body other information from the fields on the form. Like the field "complaintdecription" and "clientname".

Now, i know about the sendobject thing, but i have tried alot and non would do what i want. Can anybody help me with the code.

Many thanks

View 8 Replies View Related

Sending Email From Form

Nov 1, 2007

Hello,

I am a little lost here. My prorgam has a form where I added a button. When clicking on the button, it is supposed to use some fields from the form and add them to an email with additional info which is added when the email opens up and is about to be sent. My boss uses Mozilla for his email account. What would be the code on the Onclick event be and do I have to set up anything else??

So far I have this code but it is for Microsoft Office Outlook not for Mozilla:

Set objOutlook = CreateObject("Outlook.Application")

Set ObjOutlookMsg = objOutlook.CreateItem(olMailItem)

With ObjOutlookMsg
.To = str_Recipient 'str_Recipient is obtained before this code
.Subject = str_Subject 'str_Subject is obtained before this code
.Body = str_Body 'str_Body is obtained before this code
.readreceiptrequested = lb_ReadReceipt
.Display 'to display the message instead of sending it
End With

Thank you very much

View 3 Replies View Related

Sending A Form Via Email

Jul 25, 2006

Hi,

So far I know there is a wizard for being able to create a button that sends a Form Report. What I really want to do though is when the user clicks the button on the form, just the form is sent/attached to the email, effectively giving the viewer/receiver a screenshot of the Form in question.

Thanks in advance,

Barret

View 8 Replies View Related

Automatically Sending Email...

Nov 4, 2004

I have looked through the forums for an answer to a problem I am having,
but I can't seem to find the complete answer.

I just started work on an inventory database that was made by other people;
it is a fairly large database. One of the forms is for equipment maintenance
and in it, you fill out several fields. What needs to be done is an email sent
out to 2 people in the department; they are selected via a combo box and this
runs a query that fills in a table with the proper email addresses and matches it
to the proper job in the table. A due date is inputted in a standard text box.
The emails are then supposed to be sent out on the due date provided.

For some reason, there is no code at all (that I can find) that even runs Outlook,
although it supposedly worked a while back. I have read that timers would help
with this, but I am not quite sure where to go with it. Also, does the email have
to be sent from the person that is logged into Outlook at the time the email is sent,
or can it be sent under another email address no matter who is logged into Outlook
at the time.

Any help would be greatly appreciated.

Thanks

View 12 Replies View Related

Sending Email With Outlook Via VBA

May 5, 2013

I have made a form to send emails, I used this code I found somewhere:

Code:
Private Sub cmdEnviarOutlook_Click()
Call EnviarEmail(Me.txtEmail, Me.txtAsuntoEmail, Me.txtLeyenda)
End Sub

[code]...

I configured Outlook with my gmail account.The code works fine (after adding references) but when I take a look to the sent-box in Gmail, I find that the email is duplicated.If I send an email normally or even using docmd.sendobject, that doesn't happen.

One more question. I tried this function in two computers and in one of them Outlook asks for permission while it does not in the other one. I believe it is related with Outlook config.

View 1 Replies View Related

Sending An Email Using Lotus Notes

Dec 12, 2006

I want to send an email thru Lotus Notes by clicking on a command button and need some help.

I have a tabular form which displays info from a make-table query. I would like to have a command button next to each record, which when clicked will send an notice(email) to the corresponding email address.

The following are displayed for each record:

View 1 Replies View Related

Modules & VBA :: Sending Email With Or Without Attachments

Jan 12, 2015

I'm working on a database for work that email's the current record after the form is completed. I have a attachment field in the table called Photo and some record's have a photo attached and other's don't. The code below works great with records that have a photo attached, but I get a path not found if I try to email a record that does not have a photo. I know that I need to put some form of code to check the photo field for a attachment, but I'm having a brain fade as to just what the code is.

Code:
Private Sub eMail_Report_Click()
Dim oFilesys, oTxtStream As Object
Dim txtHTML As String
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem

[Code] ....

View 5 Replies View Related

Modules & VBA :: Sending Email With PDF Attachment

Dec 16, 2014

i am trying to send a email with a pdf-report attached based on a report (rap_factuur_klant_pdf).I am using MS Access 2007 and Outlook 2007..

Code:
Dim sAddr As String, sSubj As String, sFor As String
Again:
sAddr = InputBox("E-mail address:")
sSubj = "Report"
sFor = Left(sAddr, InStr(1, sAddr, "@") - 1)
DoCmd.SendObject acSendReport, rap_factuur_klant_pdf, acFormatPDF, sAddr, , , sSubj, "BLA BLA BLA"
DoEvents

View 5 Replies View Related

Modules & VBA :: Sending Out Automate Email

Jun 25, 2013

I use a macro (SendObject), which works, but it requires Us, or someone to go into Outlook to click on send.I'm new to vba, do I have to code something on outlook to send automatically?

View 6 Replies View Related







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