Email: Subject Title

Mar 11, 2005

Does anyone know how to put in a file reference number automatically into the subject bar of an email?

This is the code that i am currently using:

On Error GoTo Err_Handler
MsgBox "THIS FEATURE WILL ONLY EXPORT FILES WITH TODAYS REFDATE"
If [CboExport] = "Today" Then
Dim rst As Recordset
Dim db As Database
Set db = CurrentDb
'Create Recordset
Set rst = db.OpenRecordset("SELECT tblAT.FileNr, tblAT.RefDate " & _
"FROM tblAT " & _
"WHERE (((tblAT.RefDate)=Date()));", dbOpenDynaset)
'Check to see if there has been records recorded today
If rst.EOF = True And rst.BOF = True Then
Beep
MsgBox "THERE ARE NO RECORDS WITH TODAYS DATE, REFER TO SPECIFIC DATE."
rst.Close
Set db = Nothing
Exit Sub
End If
'Export query as MS EXCELL

DoCmd.SendObject acSendQuery, "qryTodaysDate", acFormatXLS, company@somewhere.com, myboss@somewhere.com, , "File reference number ?????????"The following file is the latest extract from me as at " & Date & "."

regards, Steve

View Replies


ADVERTISEMENT

Query Result As Email Subject

Jan 8, 2007

Curently run a Send.Object function on a form to retrieve a unique record via a query. I'd like to be able to send a particular field returned by the query to use as the subject title in the email that is auto-created.
The query will only ever be returning a single record but that single record will change each time it is run.


Any ideas people?


Thanks in advance.

View 1 Replies View Related

Email In Snapshot Format And Subject Line

Oct 28, 2004

Hi,

I have been reading all of your post for days now and can't find the answer to my question.

I have however found the answer to one of my programming problems. Thanks to all of you.

I have used Access as a data supplier but this is my first attempt to program in access.

I have absolutly no experience with VB code. And a limited amount of experience with macros in access only.

My question(s) are:

1. I need to send a single report (page) in an email (snapshot format) to a person using a command button. This report should be sent from the form that the person is currently looking at. Currently my command button sends the report in snapshot format but it sends the whole database.

2. This report will be used as a tracking mechanism for another department and I will need a specific name to store the email in a certain location. So that it can be tracked at a later date. I want (that doesn't mean that it can) Access to automatically put the subject line in the email. I know under the sendobject macro you can set the subject line the same for each email. But I need the subject line to match the information in several of my text boxes from a table. For instance: Subject line should read: [Permit number][CountyId][Inspector's Initials][Date]. Can this be done at all and if so how.

Thanks so much for all that you have done already.

Tasha

View 14 Replies View Related

Modules & VBA :: Edit Subject Line Of Outlook Email

Aug 27, 2014

I'm trying to write a line of VBA code (in an existing Access 2010 DB) that changes the Subject Line of all selected emails in my Outlook Inbox to today's date.

View 1 Replies View Related

Is Replication A Taboo Subject?

Jul 27, 2005

I have posted on a couple of other sites and have not had an answer in two days on a replicated database question. Is this a taboo subject, or is there just not a lot known about it?

I have a FE/BE Database that has 25 users. Two of these users moved offsite and are having huge speed issues. What I have gotten out of my research is the best thing to do is create a replica of the backend and transfer that replica to the offsite agents pc. This way everything is on their C drive instead of the BE being on the network and the only speed issues they will have is when they synchronize the replica w/ the backend.

Here is my problem. How do I create a button on the FE of the Database that will cause the BE on their PC to synchronize with the Design Master BE on the network?

I have a limited understanding of VBA.

Any Help would be appreciated.

Thanks,

View 3 Replies View Related

Reports :: Multiple Lists On A Single Subject

Jan 21, 2014

I have been asked to make a report from my database listing property sites and listed things found with them. Ex. a property might have 3 houses and 2 cars on it. Whenever I make a report the best I can make are groups that look like:

Property 1
House A
Car a
Car b
Car c
House B
Car a
Car b
Car c

I need something that could group car and houses directly to property 1 rather than cars grouped to houses grouped to property.

Ex.
Property 1
House A
House B
Car a
Car b
Car c

View 4 Replies View Related

FieldNames In Subject Line Of SendObject Action In Macro

Aug 6, 2004

I have a Macro setup and SendObject is one of the Actions. It is setup to send an existing report. Is there a way to insert a fieldname from that report into the Subject line of the e-mail that is sent? That would be great, instead of having the same subject line for every e-mail, using the date or something like that. Please let me know. Thanks.

View 3 Replies View Related

Modules & VBA :: Update Subject Of Emails In Outlook That Have Already Been Received

Jul 22, 2014

I'm trying to automate some processes. My company uses Outlook 2010 and every day we need to go into our "Sent" folder and rename the Subject line of all of our sent emails. We change the subject to a standardized format depending on the content of the email and who the email was sent to. These are then used as part of an equation to tally our Transactions Per Hour. (TPH)

I've already designed a small Access 2010 utility to track the TPH, but I would like to add the functionality to parse some data from the subject lines of my "Sent" folder, and automatically make changes to save some time.

Here is my thought process:

- Click "Process Sent Emails" button from TPH utility.
- Access runs through each email in the "Sent" folder (or perhaps only selected emails) and changes the Subject line per simple Select Case criteria (I can figure that part out).

View 2 Replies View Related

Modules & VBA :: Add Field Values In Subject And Body Of Mail

Feb 4, 2014

I have a script that sends a mail using outlook to a different person depending on a value in a field. I want to add values from fields to the subject and body of the mail it creates. This is what I have so far:

Function Mail()
On Error GoTo Mail_Err
If (Forms![Manage Packages]![Customer] = "MSC") Then
DoCmd.SendObject , "", "", "email", "email", "", "[ID] - [Package Name] - Delivered", "Dear," & vbNewLine

[Code] .....

In the subject and body the field ID's I want to add are marked as [ID], [Package name] etc.

View 8 Replies View Related

Manual Auto Numbering Subject To Change In Date Field

May 18, 2006

Greetings everubody,

I've a problem and hope to get answers for,

The situation is that I have a table named patient and a form named [patient1] where it holds a textboxs named "MFC_Seq_no" and another to hold [date], now, I manged to do a manual auto numbering for "MFC_Seq_no" using the following VB :

Private Sub Form_Current()

If Me.NewRecord Then
On Error Resume Next
Me!MFC_Seq_no.DefaultValue = Nz(DMax("[MFC_Seq_no]", "Patient"), 0) + 1
End If

Whenever user create new record, the system will automatically store the next number in the new record.

Now, I've be requested to code that system to start again from 1 as value for "MFC_Seq_no" whenever there are changes in date field (i.e. next day in the date field)

Is this doable and how?

Q2. how to duplicate an entire record with a subform, from another table, in it?

Thanks,

View 2 Replies View Related

Queries :: School Database - Student Rank In Individual Subject

Sep 25, 2013

I am developing database for my school. I am done with everything except the examination aspect where i need to indicate students position in every subject beside their overall position according to the sum of all the subject scores. How to indicate student position in subjects.

View 2 Replies View Related

Modules & VBA :: Unable To Capture A Newly Arrived Mail In Outlook With Respective Subject Line

Jul 14, 2015

I am trying to capture a newly arrived mail in outlook with respective subject line. The below code works for me on 2010 outlook but when new mail arrive in outlook 2013 ,Mrthod Items_ItemAdd do not get called.

Code:

Option Explicit
Private WithEvents Items As Outlook.Items
Private Sub Application_Startup()
Dim olApp As Outlook.Application
Dim objNS As Outlook.NameSpace
Set olApp = Outlook.Application
Set objNS = olApp.GetNamespace("MAPI")
' (1) default Inbox

[Code]...

View 10 Replies View Related

Not Even Sure How To Title This One! :)

Apr 3, 2008

I will try to explain what I have, but for a little more information please see the thread where I was trying to get a single instance of this query to run: http://www.access-programmers.co.uk/forums/showthread.php?t=146582

This above thread was to allow users to select a valid month from a "quota" table of data to compile work data for that particular month. The way this all works is I delete a history table, append the data from my work table, and then add the data from a quota table. Each time a user runs this report, those three queries run dependant on the month selected. At the bottom of this report I sum up the columns to give an overall total for production numbers. The table is set up as:
For MMM YY (selected)
Item........Repaired......Quota
widget1........1...............3
widget2........2...............0
widget3........6...............4
widget4........2...............2

Now what I need to be able to do is to retrieve all these totals at once; so that the numbers can be graphed by month. This history table that is built is not perminantly stored; since all the 'data' for it is contained throughout a couple other tables. I didn't see a reason to need to store 'all' that data again since it could be retrieved as needed.

Is it possible to write a query that will run this process for all distinct dates in the quota table and sum the data for repairs and quotas? Something like this:

Date.........Repairs........Quota
MMM YY.......18..............8
MMM YY.......27..............10
MMM YY.......16..............18

Or have I bitten off more than I can chew :)

View 7 Replies View Related

Put A Table Value In The Title Bar

Oct 9, 2006

Hi,

I want to put a value from a field in a table in the Title Bar.


So far i have done (Looking at 2 ways to create, 1 with module below or directly in the form, only just lloking at the module way so is not finished as i am waiting to get it to work directly first):

Module
Option Compare Database

Function ChangeTitle()
Dim dbs As DAO.Database
Dim prp As DAO.Property
Const conPropNotFoundError = 3270

On Error GoTo ErrorHandler
' Return Database variable pointing to current database.
Set dbs = CurrentDb
' Change title bar.
dbs.Properties!AppTitle = "DYSMS " & (SoftwareVersion.tblSoftwareInformation)
' Update title bar on screen.
Application.RefreshTitleBar
Exit Function

ErrorHandler:
If Err.Number = conPropNotFoundError Then
Set prp = dbs.CreateProperty("AppTitle", dbText, _
SoftwareVersion.tblSoftwareInformation)
dbs.Properties.Append prp
Else
MsgBox "Error: " & Err.Number & vbCrLf & Err.Description
End If
Resume Next
End Function

Directly

Does not work
Dim stAppTitle As String
stAppTitle = "DYSMS " & (SoftwareVersion.tblSoftwareInformation)
Me.Caption = stAppTitle

Does work
Dim stAppTitle As String
stAppTitle = "DYSMS " & (Now())
Me.Caption = stAppTitle

So need to declare the SoftwareVersion field i guess??

Thanks

Dan

View 4 Replies View Related

How To Make A Title!

Apr 17, 2007

Hello!

In my form I have the title of a CD which is under the name of 'CD_Title' which is taken from my CD's table and I was wondering how to show it up in a Label so when I flick through the albums the Label changes to the album that it is selected!

I need to know...please help me!

:(

View 3 Replies View Related

Column Title

Mar 10, 2006

For Access 2003 - is there a way to stack one word on top of another when you rename a column? So, instead of having two words side by side for a column title, is there a way to put one on top of the other?

For example - change from this "today's date" to "today's
date"


Thanks

View 1 Replies View Related

Title At Top Of Form?

Feb 23, 2005

This should hopefully be an easy one for somebody:

How can I not display the title of any opened form at the very top of the screen. I would prefer to have the switchboard title remaining visible instead of the form title.

For example I have a form called 'frmPC' so the top of the screen shows 'frmPC : Form' when the form is open.

Anyone?

Much appreciated,

Paul

View 2 Replies View Related

Title Case

Mar 21, 2005

i have a form, and i would like that on one of the fields, as soon as i type something in it when i leave the field, i want it to automatically convert it to title case. can this be done please?

Cheers

View 1 Replies View Related

Setting A Title?

Mar 25, 2005

I know that you can change the title of your application in the startup options in Access.

But can it also be done by vba code at runtime?

View 1 Replies View Related

Window Title Vs. File Name?

May 30, 2007

I have an *.mdb file with a bunch of tables, queries, forms, macro's etc. The file is named "xxx" but the display in the top left hand corner of the access window (next to the red key) is "yyy". I've looked everywhere and can't seem to find where this information is stored - as I need to change the "yyy" to match the filename "xxx" (the *.mdb was originally used for something else). Anyone know where this info is stored or how to change it?

Thanks in advance to those who respond!

View 3 Replies View Related

Group Columns Under One Title

Jun 23, 2007

This is the table:
ID | Item | 2/2/07 | 3/2/07 | 5/3/07 | 7/3/07
---------------------------------------------------------
101Tap10152010
102Ply25201010

Note that 2/2/07 till 7/3/07 are field names having purchase quantity.

Now I want the query to show something like this:

ID Item <----Feb------> <-----Mar------>
2/2/07 | 3/2/07 | 5/3/07 | 7/3/07
---------------------------------------------------------
101Tap10152010
102Ply25201010

I want the two columns 2/2/07 & 3/2/07 to be combined under one field name 'Feb'. Similarly for 'Mar', combine 5/3/07 & 7/3/07.

Open attachments to have a clearer picture.
Please help me out over here.

View 1 Replies View Related

Query Title When Printed

Apr 23, 2008

I have a cross_tab query, that users print on a monthly basis.

The user selects whether they want to include data for one or all of three products. So the query could show data for example for Salmon only.

I need to be able to show on the printed query, what products it is displaying for. At the moment the query is called "TotalxProccessor_Product". Once the query is printed there is no way to tell if it is for Mussels, Salmon, Oysters or all three products.

Is there an easy way to manipulate the title the query prints our with?

Or do I have to go through a report to have control?

View 1 Replies View Related

What Event Is Associated With The Cancel Box In The Title Bar?

Mar 3, 2006

Hard to search for ths really, but I have a form with two buttons: Save and Exit.

Save saves the current record

Exit does an Undo if the form is .Dirty


If I cancel from the title bar, then the records are saved and the Close event is activated.

What I need is to detect if the Cancel box was clicked so that I can do an Unload before the form closes

TIA

Liam


btw, I'm getting the hang of this. It's a lot different from mainframe Cobol but it's fun to learn new stuff.

View 1 Replies View Related

Cannot Change Column Title

Nov 12, 2012

I'm using Access 2010. After creating a new database the standard screen appears that contains a grid to enter data and across the top of that grid is a row which is supposed to contain column titles. According to Microsoft Access all I have to do is double-click the column title so that I can set it to whatever text I want. the cursor remains in the next row assuming I want to enter some data. Why can't I change column titles from their default values?

View 3 Replies View Related

Need More Than 64 Characters In Title Field

Oct 24, 2014

Any workaround so that I can place more characters than the 64 limited in a field header.

In essence, I need to export a text or CSV file from Access every day, and the row header for the first column (i.e, in cell A1 if opened in excel) needs to read:

"Action (SiteID=US|Country=US|Currency=USD|ListingType=Hal f|Location=US|ListingDuration=GTC)"

I am currently unable to have a field header with that length, because Access does not allow my table header to be more than 64 characters.

View 7 Replies View Related

Changing The Title On Error Message Box

May 5, 2006

I saw the solution to this on this forum a while back but no matter what I search under I cant seem to find it again!

Can someone remind me how to change the Title of the error message boxes I can change the error message - by changing the Err.Description - but how do you replace the 'Microsoft Office Access' with your own Title?

I am running Access 2003 on XP.

View 1 Replies View Related







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