Modules & VBA :: Send Object - Adding Option To Include CC

Aug 27, 2014

I have a data base in access 2007, and I'm trying to add into my code one option that includes in the CC: field contacts that I already have in my DB.

This is my code:

Dim rs As Recordset
Dim vRecipientList As String
Dim vMsg As String
Dim vSubject As String

[Code] ......

View Replies


ADVERTISEMENT

Include Object Library With Runtime.

Sep 15, 2006

I have an application which includes a process that creates an excel sheet with some data. For this I have set reference to the excel object library. I am now packaging a demo of the application with Office Developer and including Access runtime. The question is what to do about this reference, since when I look at the file that it uses, it shows Excel.exe. I don't suppose I can legally be sending that file along with my program. Is there a different reference that I could set that would give me what I need? I noticed this in testing because it is the only reference file that wasn't automatically included in the package.

Thanks,
Tom

View 1 Replies View Related

Include Wildcard Option Within Form

Feb 23, 2006

This may well be a simple question.

I have set up a Form to report Client acitivity by department Code for a given month. Users have the option within the form of selecting a Department Code.

These department codes are derived from a department Code Table and set accordingly within my Row Source properties.

If I wanted to select multiple departments for a particular report. how can i allow for wildcard entries i.e if several department code begin with letters OD*?

Thanks

Paul

View 1 Replies View Related

Include Bound OLE Object In Mail Merge

Feb 6, 2006

Is it possible to include a bound OLE object in Access in a mail merge using a Word document? If so, can someone tell me the procedure? When I include the OLE object as a merge field, and complete the merge, only a code shows, not the document it is linked to.

View 2 Replies View Related

Forms :: Include Option In Combo Box To Create A New Item

Jun 20, 2013

I have a form with a combobox whose list items are taken from a table of currencies (called tblCurrencies)

Row Source = SELECT [tblCurrencies].[Ccy] FROM tblCurrencies ORDER BY [Ccy];

Problem is, there may come a time when the currency they want to select is not yet part of the tblCurrencies table, and needs to be added. For simplicity, I'd like to have an additional option in the dropdown (perhaps at the bottom) to specify a new currency.So an additional list item (e.g. 'Add New...') which when selected could prompt a subform where the user could specify the new currency (and any other relevant details specific to that currency) which can be programmatically added to tblCurrencies.how do I get that extra option into the list items for the combobox?...

View 2 Replies View Related

Send Object

Oct 4, 2006

Is there a way to tie a send object to a combo box on a form? I know I can write a query to pull information from a selection in a combo box using the [form][formname]thing. What I'm trying to do is I've created a database that allows many users to enter a request in a form. then when the form is complete they need to E-mail the form to their respective manager. I want them to choose from a combo box, then click on a button and the form is e-mailed to their manager for approval. I've gotten everything else to work accept for being able to choose the manager. I know I could also leave that blank and it will ask for them to enter the recipients name. If that's my only option I'm ok with that.

Thanks

PS If this issue has already been addressed I couldn't find it.

View 1 Replies View Related

Faxing A Form With Send Object.

Nov 3, 2005

i have a form, every post on this form is connected to a deliverer in a table, every deliverer has a faxnr.
I want to be able to push a button on a form and it will fax the form to that deliverer, how woud this be done?
Ive checked that microsoft page about send object and stuff but i dont get much and it doesnt seem to be what i want to do.
Is this thing even possible in access?

When i try a sendobject command, i get "coudnt start the mail software, check that the software works" translated from swedish.@@1@@1

View 1 Replies View Related

Send Object Via Lotus Notes

Nov 14, 2005

Hi ,
In MS Access,

I used sendobject to send the object via Lotus Notes, but I want to skip to click the Send button from the Lotus Notes, everytime, when I sent, it goes to the Lotus Notes, then I need to click the send button again on the Lotus Notes for confirmation to send the mail. How can I skip it?

sendobject ........................, False

I used False or True, it still cannot be solved.

Please let me know, thanks.
Thanks.

View 1 Replies View Related

Send Object Macro Via Outlook

Dec 23, 2005

Hoping someone can help - need to know if there is a way to use a Outlook message other than the blank one that is used with the send object macro.

Maybe a normal message with a signature, template or something - when the macro is run, no formatting is included with the e-mail message, and the body of the message is limited to 255 charaacters.

Would like to use a customized message, and I need the send object macro to place the object in that message format.

If anyone can help, I would greatly appreciate it...thanks.

View 1 Replies View Related

General :: Emailing With Send Object

Nov 23, 2012

I am using a command button to email an invoice to a customer using the sendobject function, whilst this almost works correctly it is adding an additional mailto:address along with the correct email address.

Example: CorrectEmailAddress and then#mailto:CorrectEmailAddress

The code I am using is:

On Error Resume Next
Dim Cusemail As String
Cusemail = Nz(DLookup("Email", "invoiceemailQ", "orderID=" & OrderID), "")
If Cusemail = "" Then
MsgBox "No email Address"
Exit Sub

[code]....

View 6 Replies View Related

Very Basic DoCmd.Send Object Help Needed

Sep 18, 2006

ok, i have been searching on google and the forums for sending forms/reports as outlook atachments.

all the examples i have seen are more complicated than my one.. i have one form.. and i just want to email those details.. in the form are the fields, one textbox where you put the email address, and one send email form button..

i got it working using a long module, that i didnt understand..and then i was told about the DoCmd.SendObject method which looks a lot easier..

i have one request, in the simple database i have uploaded, will someone show me where to put the code.. the db is VERY simple, and quick (one form with a send email button).. and if anyone can spare a few minutes to get this one working i will be very grateful..

View 3 Replies View Related

Change Output File Name During Send Object Routine

Apr 3, 2007

I have a query that runs based on a parameter a user selects on a form.

I want to dynamically create the sendobject file name based on the parameter the user selects.

Example:

My form has a parameter named medicine. When the user checks the checkbox next to medicine it runs a query for records labeled as medicine but sends the e-mail output as the query name. I want something like medicine.txt etcc...

thanks

:confused:

View 1 Replies View Related

Forms :: Send Object (Encrypt And Digitally Signed)

Apr 25, 2014

When using SendObject to send an e-mail, is there code to turn on the following?

- encrypt,
- digital signature and
- read receipt

Or must the user activate these when the e-mail is generated?

View 2 Replies View Related

Forms :: Using HTML To Format Body In Send Object Method?

Jun 26, 2014

Can I use html to format the message body in send object method ? If I can, how to do that.

View 5 Replies View Related

Adding Help Files To Option

Apr 5, 2008

Hi there, really simple question

I just wanted to know if I could edit the access interface so that the access help options would not be displayed, but I can add a link to my own created HTML help files for the system I have created. Is it possible?

View 1 Replies View Related

Adding Calender Option To Access

Jun 29, 2006

my departments seems to want to add some sort of notification feature to our database. It's supposed to notify the department when a certain date is approaching.

How do you even begin to think about adding this feature into Access? I don't know where to start. I'm no Access guru. :confused:

View 1 Replies View Related

Adding List Option Automatically

Aug 7, 2006

This is probably something already talked about, but if i have a combo box that has an "Add New Entry" selection in it, and when the user clicks on it, i want to add what they want in to the table that the combo box chooses from. can I have that "Add New Entry" selection open a form with a text box, and then have that value enter into the table? What is the easiest way to do this?

View 3 Replies View Related

Adding Text Option In Lookup List

Jul 20, 2013

I was checking if it is possible to add a text option after creating Look Up Tables, and I am also getting extra spaces while creating lookup tables where the drop down list goes more than 100 items.

View 2 Replies View Related

Modules & VBA :: Include Query In Body Of Email

Jan 30, 2014

I have a query table in Access 2007 with requests pending an individuals review and approval. I would like to create an automatic email each day to that individual which includes the actual query table impeded as part of the body of the email (not as an attachment).

View 1 Replies View Related

Modules & VBA :: Execute A Query That Does Not Include Specified Expression

Aug 21, 2014

I am getting the following error message in strsql:You tried to execute a query thats does not include the specified expression 'ScanDate=20140730 and SCanhour=8' as part of an aggregate function in the following strsql.

Code:
Call func1("Z", 8)
Public Sub func1(b As String, a As Integer)
strsql = "SELECT Count(BatchNo) AS CountOfBatchNo, Sum(Envelopes) AS SumOfEnvelopes, Sum(Cases) AS SumOfCases, Sum(Pages) AS SumOfPages, ScanDate, [Type] & Format([Type1],'00') & Format([Type2],'00') AS QueueNo " _
& "FROM jabberwocky " _
& "group By ScanDate, [Type] & Format([Type1],'00') & Format([Type2],'00') " _
& "HAVING ScanDate=" & J & " and Scanhour=" & a & ""
End SUb

View 8 Replies View Related

Queries :: Adding Currency Conversion Option Into A Query?

Aug 19, 2014

We have a query that calculates the cost total of three different types of costs between three different parameters. I now need to run a query that prompts the user for the days currency conversion rate to create a new report. I don't want to permanently convert the original fields, it is purely a monthly report where when the report is run is shows both British £ and USD.

View 3 Replies View Related

Forms :: Adding Search Option In Main Form

Jun 25, 2013

I have two tables called "tblFundingBodies" and "tblGrants". I have a form that allows me to view all the records for each of the funding bodies. By this I mean, it shows information on a funding body but to see information on the next funding body, I must click on the next record button. Just wanted to clarify that it isn't in the form of a table.

This form also has a subform in the same format that shows each of the grants that funding body has provided. When I select the next record from the main form, it will show me the grants from the company in the next record. The field that has the funding body is a text box.

I want to be able to add a seach facility to the main form that allows me to search for a funding body and get back exactly what I have described above, but just the details on that funding body/grants. In other words, I want the form view of the funding body I search for with the sub form of the grants from that funding body, not in the form of a table where you can see them all at once, I want to be able to click through each grant in the sub form.

View 6 Replies View Related

Modules & VBA :: Delete A Folder To Include Subfolders And Files?

May 25, 2015

I need a way to delete a folder along with subfolders and files associated with a record via command on a form:

The path is stored in a text field "txtDocuments".

For example: "C:UsersWatsonDesktopFY1515051505-010"

So, I would want the code to pull the folder location from the txtDocuments text field and delete folder "1505-010" and all sub folders & files contained within it.

View 4 Replies View Related

General :: Dynamically Adding Option Controls To A Frame On A Form

Aug 20, 2012

In Excel, I can dynamically add option controls to a frame on a form using the Control.Add method. Is there an Access Equivalent? I can only find Count & Item as Control. items.

It might have something to do with design view i guess.

View 5 Replies View Related

Modules & VBA :: Selecting Fields - Change Text To Include Data From A Table

Nov 5, 2014

I have an on click event to mail a report which works. I want to change the text to include data from a table.

I changed the code to include the field 'office' from the table 'Checks' but get an error saying 'Object required'.

Code is :
Private Sub cmd_mailreport_Click()
Dim office As Object
Set office = Checks.office
DoCmd.SendObject acReport, "checks", "PDFFormat(*.pdf)", _
"info@company.com", "", "", office & " Daily Check - " & Date, "Attached is the report for the office", _
True, ""
End Sub

View 1 Replies View Related

Modules & VBA :: Writing Code To Open Query After User Selected Fields To Include From ListBox

Jan 14, 2014

Access 2007-10
Listbox created: List62 (I know I need to rename it, but for now)
Multi-select: Extended
Row Source Type: Field List
Row Source: qryFieldList
Open Query: qrySelectedFields (I added primary key to first column, just to have at least one destination field).

Goal: to select multiple fields within listbox, click on command button to open query "qrySelectedFields" with selected fields from list box.This is the code I have on the command_click:

Dim varItem As Variant
Dim strSQL As String
If Me.List62.ItemsSelected.Count = 0 Then
MsgBox "Please select one or more fields.", vbExclamation, "Healthcare REIT"
Me.List62.SetFocus
End If

[code]....

It does absolutely nothing - doesn't add the fields to "qrySelectedFields", doesn't open the query, notta.

View 8 Replies View Related







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