Collecting the Data entered onto a form into a access table.

I have designed a form in outlook 2003 and want to collect he data in a 
access table when the form is used to send email. Can any one please help me 
as I am stuck. I have linked the table to the form but nothing happens when 
you use the form and send a email. 

11/29/2004 12:51:43 PM
outlook 87535 articles. 11 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 32

You will need to write code. See 
for links to samples, etc

Sue Mosher, Outlook MVP
Author of
     Microsoft Outlook Programming - Jumpstart for
     Administrators, Power Users, and Developers

"Claude Brandon" <> wrote in message 
>I have designed a form in outlook 2003 and want to collect he data in a 
>access table when the form is used to send email. Can any one please help 
>me as I am stuck. I have linked the table to the form but nothing happens 
>when you use the form and send a email.

suemvp (4038)
11/29/2004 8:37:07 PM

Similar Artilces:

Showing specific data
In A2003 I was able to put a command button on a form that when clicked would display another form which would contain specific data; i.e. a form of employees would then disaplay their absences. I built the button through the wizard and selected the "open form and find specific data to display". This works fin e in A2003, but when I build it ion A2007, the resulting form displays all my data, but says it's filtered. Can I see just what I want to see? Thanks Nigel, Since you are opening a new form from another open form, and the "calling" form has a key value...

SQL in Excel data
Hi all, Is there a possibility/way to run an SQL query in an excel data sheet? I have quite some data like the sample below, now i would like to have the sum of spending for each person. Like it is possible in Access. A1 B1 Field1 Field2 Chuck 12,89 Mike 23,09 Jean 9,34 Chuck 30,00 Mike 3,80 Chuck 22,00 Mike 7,23 Jean 10,55 Jean 10,75 Jean 31,45 Chuck 19,99 Result Field1 SumOfField2 Chuck 84,88 Jean 62,09 Mike 34,12 Advice would be appriciated. Cheers, Ludovic Hi You could use a formula like this ...

Vista Access 2003 & Ole
I have a DB I've been using, updating for several years. I use a = different BMP on every record. Today I started to update it again. Last = update a few weeks ago on my XP. Today I went with 'insert object' 'create from file'. with XP I couldn't = use JPG's so I made bmp's. Today even a bmp is just an icon. How do I get the create from file to work again ? --=20 more pix @ ...

How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from the following XML file: <?xml version="1.0" encoding="utf-8" ?> <Robot xmlns=""> <Parameters> <Name>Decker</Name> </Parameters> <Parameters> <Name>A</Name> </Parameters> <Parameters> <Name>B</Name> </Parameters> </Robot> There will be more data than just a name for each Parameters node. Here is my code: Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...

Form for table
Here's the problem: Access 2003, XP Pro- I have three tables that are related by primary keys. I have a table[Table QC] that has the field [EmployeeID], the data type is number--that field is linked to the autonumber primary key of the Employees Table. So far so good. I am trying to make a form that has a combo box that looks to the Employee Table to get me the drop down of the employees (Last Name, First Name). The SQL statement builds out okay, and I get the correct name config., but because the data type is a number it won't accept the data. I looked at the Northwind example and i...

Build Dynamic Query from Form
I am trying to build a dynamic Query from a Form. I keep getting an error that reads ‘Object qryFilter already exists’ I suspect it has something to do with the string of dates being passed to the Query; strDateCondition = "([Trades].[TDATE] Between [Forms]![SearchForm]![cboFrom] And [Forms]![SearchForm]![cboTo])" I am trying to add a means for a user to Query by Customer and Trader AND all records between two dates. This was working fine for Customer and Trader; when I added in the code to filter by dates I started having problems. I know the SQL will be li...

No Form Assistant in Quote Product Screen
While entering data in the QuoteProduct screen, no Form Assistant is available. Is it the usual feature or I need to configure something to view the Form Assistant? Also is it possible to see contact hierarchy in an account in the form of a Organisational Chart? Is their any add-on available in relation to this? ...

building form @ runtime vs. hiding existing controls
I'm trying to decide just how bad runtime design is. Most opinions seem to steer clear of adding controls, events, etc at runtime. Instead, y'all advocate keeping controls on the form and hiding them as necessary. In my application (which will not be an MDE) , each user session builds a new form - from scratch. Once the form is built, there are no design changes. And when the user is done the form object is deleted. Troubleshooting may be more difficult with a form that only exists at runtime. OTOH, documenting and tracking unused controls (or not having enough controls, ...

Count unique values
Hi, I've some problems to count unique items (Invoice #) in a pivot table. There is the default solution "Add-a-new-calculated-column" as mentioned on, but in my case, it doesn't works. My problem is, that these values aren't in a Excel worksheet; it's a external data source - a SQL-Select via DAO/ADO. Because of that, I don't have the possibility to add a new column. Another reason is, that the pivot table should always be dynamic: Group over this field, group over another field - and always show the number of unique...

unable to access mail after re-enable account
Hi, After enable an disable account and change its password, it can login to its mail account. What's happening. Is it normal? Thanks a lot What is the error message when user tries to access mailbox? Does the user still show in ADUC has having Exchange attributes? Have you looked at the MB using ESM to see if it is disconnected? "Raymond" <> wrote in message news:136c01c46f11$d16f8390$a301280a@phx.gbl... > Hi, > > After enable an disable account and change its password, > it can login to its mail account. What's hap...

Sum in Form Footer
Hi Folks, I've made a the following calculation in form Detail section into text box and I've called my text box "Chaussures" =Sum([Chaussures])+([aldo])+([Feet-First])+([Transit])+([Globo]), this sum calculate the sum of Units which are into these text boxes "aldo", "Feet-First", "Transit" and "Globo" and this for each line record. Now in the Form Footwear, How can I make the total of units "Chaussures" I've tried a lot of things and nothing seems to work. Your help will be much appreciated, Thankign you in advance,...

Keyboard hooking through Accessibility
I am looking for a method to hook the keyboard without running a background process. I know there are APIs for hooking (SetWindowsHookEx), but I want to avoid the overhead of running another background process for this and make the task do by windows itself. I am thinking of tweaking the Accessibility option in windows for this. Can we anyway do this by writing any script or modifying or adding registry entries for Accessibility? Or is there any Accessibility specific APIs which can re-program the Accessibility feature to do our tasks when we press a key with Accessibility feature-on. An...

Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my classes.(Alphabetized names down left vertical column. Dates across top of horizontal row.) I added a different color to all cells in every other row to make for easier reading of each student's name and absences. Every other row stays with a white background. My question: I wondered if it was possible to lock row colors while allowing data to change on top of them. If a new student is added to my class in alphabetical order, the alternating color pattern is often lost. It is a pain to rechange row and cell colors. Any shortcut ...

How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data.. Refresh Data to requery the source, but I want to be able to do it in a more automated way. Is there some sort of macro I can write when opened or something? Thanks, Ron Ron, Select the cell the data starts in, select Data/Import External Data/Data Range Properties Check the box "Refresh on file open" and anything else that needs checking off... Other than that, you could record a new Macro that selects your cell, refreshes data, and assign the macro to a keystroke, or even an icon. Beege ...

Appending in a sub form
I am creating a venue ticket tracking DB in Access '07. tblVenueEvent has info about Venue, date, time, event with a VenueEventID (key field) which is linked to tblTicketInfo which has section, seat, row, etc. I set up an entry form completing VenueEvent info with a sub form for ticket info. Some of the venues have a standard set of seats that I want to "auto populate" into the sub fom. I have set up a Venue table with the standard seats for the venue. I can set up an Append Query on the sub form, which does append the tblTicketInfo, but does not capture the VenueEven...

List Running Horizontally-Pivot Table Possible?
I just had a customer ask this one and I'm not so sure about it. 1) The customer has setup a list of information that is running horizontally instead of the typical list running vertically. 2) I just taught him how to do pivot tables and he wants to generate a pivot table with his "horizontal" list. 3) I know he can copy and paste special and use the Transpose feature to change the list from horizontally oriented to vertically oriented. 4) the question is: can he leave the table in its original orientation and still generate Pivot tables? I can't seem to make it work ...

Running an Excel Macro from an Access Command Button
Hi , Can anyone help me with this, I am trying to run an excel macro from an access command button. I want the macro to Bold the Headings on a excel spreadsheet. The code runs without any errors but the macro doesnt seem to work, I think I have got the line ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong The code: Private Sub cmdRunMac_Click() Dim ExcelApp As Excel.Application Dim ExcelBook As Excel.Workbook Set ExcelApp = Excel.Application ExcelApp.Visible = True Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and Settings\...

Question About Missing Data
So, this is probably really easy, but I just want to ask and see if I may be missing something here. Some data on vendor numbers changed. Let’s say IBM used to have a vendor number 12345 and now it’s vendor number is 56789. I can identify IBM as IBM, but I really want to use the number, not the name. Should I set up a table that ties the numbers together, so that Access knows 12345 = 56789? Or, should I do some kind of Update Query and change all incidences of 12345 to be 56789? Or, is there some other, method, like a ‘best practices for missing data’? Thanks! Ryan--- ...

Outlook Data Files #4
I've done some reading but I'm still confused about the use of Office Outlook Personal Folders File (.pst) versus Outlook 97-2002 Personal Folders File (.pst). I understand the basic "Office Outlook Personal Folders File (.pst) to create a new Outlook 2003 .pst file. Click Outlook 97-2002 Personal Folders File (.pst) to create a new Outlook .pst file that is compatible with earlier versions of Outlook." When we have upgraded to Outlook 2003 or set up a new PC with Outlook 2003, when adding PST's you can chosse either of the two file type options and browse to chos...

New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet via a macro, a new named range (for the same range) is created. This does not pose a problem, but after a while, I'll have a huge number of named ranges that will never be used. Why does Excel name the range and how can I stop this? I noticed in the recorded macro, there was a line .Name = "drd_5". I commented this out to see what would happen, but it just renamed the range "ExternalData_5". The next one was "ExternalData_6", etc. Thanks, Carroll Rinehart You could refresh with differen...

Is there a way to convert OE 03 form templates?
I have a user that has upgraded from outlook 2003 to outlook 2007 and has a form template from 2003 that is in a FDM extension. Outlook 2007 is unable to read this form. Is there a way to convert this form, or will the user just have to create a new form with their new version of outlook? Any information appreciated. Thanks, -AllenK What happens when you try to install the form? Any error message? -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 Outlook FAQ, HowTo, Downloads, Add-Ins and more

tasks entered in taskpad don't appear in task folder
All of the tasks that I have entered via the taskpad do not appear in the task folder, what am I doing wrong or do I have the wrong expectation? OL98/WinXP John Keith What view are you using on your Tasks folder? --=20 Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. "John Keith" <> wrote in message = | All of the tasks that I have...

Multiple Item Forms
Hi. I am new to your form and am struggling with the Multiple Item Forms. I want a combo box on the top that will select an id number from a table called 'SurveyA'. The multiple item form should then only display the records in a table called 'ActTravDiary' with that id number. As the ID number is changed a new group of records should be displayed in the form. I know how to initiate a change in one combo box based on another combo box (i.e. Row Source), but I cannot find a similar property for the multiple item forms. Please help. On Fri, 12 Feb 2010 21:00:2...

Times Subtraction Whith Access
Hi I need to know how to subtract between two times variants and to get a time result (With Access). Like this: VarTime=[time1]-[time2] 10:05:40=18:05:50-08:00:10 Thanks Access really isn't intended to do things like that, but ?Format(#18:05:50# - #08:00:10#, "hh:nn:ss") 10:05:40 -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) <> wrote in message > Hi > > I need to know how to subtract between two times variants and to get a > time res...

DAO, Access, zero-length strings?
How can you set that you want to allow zero-length strings in a MS Access database with DAO? Also, how can you set that you want default values? Access doesn't seem to allow "DEFAULT" property... ...