Visual Basic :: Getting Header Data From Emails???

Outlook 2003 Emails Missing Full Header
I have a question,

I'm using the Microsoft CDO 1.21 library to extract the full headers from emails in my Outlook and I'm having problems. My code (very much helped out from awesome examples on this board) will grab the emails and extract the headers, but... for some unearthly reason it seems that Outlook doesn't keep headers for all emails Most are fine but other emails have no header what-so-ever. Verified by right clicking on the email in Outlook and selecting Options, there is no full header displayed.

Does anyone know how to get the full header from every single email in Outlook? Also, sometimes the headers don't properly include it's attachments, what gives?

(I've also checked other people's Outlook emails here at work and it's a common occurance)

Thanks!

Placing Text Fields In The Report Header Or Page Header Sections Of A Data Report
Is it possible to place text fields in the Report or Page Header of a Visual Basic 6 Data Report?

Sending Data In Emails
I'm using an Access 2000 database to store data about dating agency clients. I have created a report that tells them who their match is, and I want to send it by email. Is there any way of retrieving their email address from the members table, and sending the report as either main body or an attatchment? Here is the code for the report.
Code:Private Sub Report_Activate()
'runs on loading form
'shows data for member's best match

'declarations
Dim datingagency As Database
Dim strsql As String
Dim rs As Recordset
Dim pmatchID As String

'asks for the member's ID
searchmemberID = InputBox("Enter the member's ID")

'opens database
Set datingagency = CurrentDb

'selects records for member ID emtered
strsql = "SELECT * FROM tblmember WHERE ([tblmember].[m_memberID] = " & searchmemberID & ")"
'opens recordset for viewing
Set rs = datingagency.OpenRecordset(strsql, dbOpenDynaset)

'finds member's name
Report_letter.txtmembername = rs("m_name")

'close recordset and database
Set rs = Nothing
Set db = Nothing

'put staffname in form
Report_letter.txtstaffname = staffname

'opens database
Set datingagency = CurrentDb

'selects records that match ID emtered
strsql = "SELECT * FROM tblmatches WHERE ((([tblmatches].[match_partnerID]) = " & searchmemberID & ")) ORDER BY [tblmatches].[match_score];"

'opens recordset for viewing
Set rs = datingagency.OpenRecordset(strsql, dbOpenDynaset)

'loop until end of file
Do Until rs.EOF
'finds ID of member with highest score
pmatchID = rs("match_memberID")
rs.MoveNext
Loop

'close recordset and database
Set rs = Nothing
Set db = Nothing

'opens database
Set datingagency = CurrentDb

'select data for match
strsql = "SELECT * FROM tblmember WHERE ([tblmember].[m_memberID] =" & pmatchID & ")"

'opens recordset for editing
Set rs = datingagency.OpenRecordset(strsql, dbOpenDynaset)

'display match data
Report_letter.txtmatchname = rs("m_name")
Report_letter.txtmatchgender = rs("m_gender")
Report_letter.txtmatchage = rs("m_age")
Report_letter.txtmatchlocation = rs("m_location")
Report_letter.txtmatchhair = rs("m_hair_colour")
Report_letter.txtmatcheye = rs("m_eye_colour")
Report_letter.txtmatchbuild = rs("m_build")
Report_letter.txtmatchheight = rs("m_height")
Report_letter.txtmatchreligion = rs("m_religion")
Report_letter.txtmatchoccupation = rs("m_occupation")
Report_letter.txtmatchemail = rs("m_email")

'close recordset and database
Set rs = Nothing
Set db = Nothing

End Sub

Thank you.

Extracting Data From Outlook 2003 Emails Into DB
I have a couple hundred text emails stored in my Outlook 2003 Inbox, with each one containing information in the body like this:

Name: Fred Smith

Email: fredsmith@abc.com

Zip Code: 90272

Does anybody have any advice on how / the steps I need to take in order to get these three fields from each email into an Excel spreadsheet? (And then ultimately a MySQL database.)

I'm guessing I first need to programmatically extract the data from each email - which can only be done with visual basic, or not?

Any assistance would be much appreciated.

Sending Emails With CDO, How To Catch Problem Emails?
I have an automatic email function in my app, and the code looks like:

Code:
formAllEmails.MousePointer = vbHourglass

'setup for email
Set objemail = CreateObject("CDO.Message")
objemail.From = emailDisplayName & "<" & emailAddressDB & ">"
objemail.To = p_email
'***************
'needs to chang to check type, then send appropriate message
'***************
objemail.Subject = "An update on from " & emailDisplayName
objemail.TextBody = message
objemail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

'Name or IP of Remote SMTP Server
objemail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = emailServer

'Type of authentication, NONE, Basic (Base64 encoded), NTLM
objemail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoBasic

'Your UserID on the SMTP server
objemail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusername") = emailAddressDB

'Your password on the SMTP server
objemail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendpassword") = emailPassword

'Server port (typically 25)
objemail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = emailPort

'Use SSL for the connection (False or True)
If emailSSL = "1" Then
objemail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True
Else
objemail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = False
End If

'Connection Timeout in seconds (the maximum time CDO will try to establish a connection to the SMTP server)
objemail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 30

objemail.Configuration.Fields.update

'==End remote SMTP server configuration section==

objemail.Send
formAllEmails.MousePointer = temp
End If
Exit Sub
hell:
formAllEmails.MousePointer = temp
If Err.Number = -2147220973 Then
MsgBox "The server could not make the connection to your email account. Please check the information and try again"
Else
MsgBox "An internal error occurred. Error code: 4000-" & Err.Number & Err.Description

End If

But the problem is this: when I am sending more than one message out if there is a problem with the email address (mailbox full, bad addy, etc) how can I keep sending all the others? I dont want to abort the process because of one bad addy or one box that is full or ...

thoughts?

Also, does anyone have a list of CDO error codes?
EDIT: found the codes: http://www.cdolive.com/cdo11.htm

Is It Poss In VB To Read Emails And Input Data (Resolved)
IS it possible in VB to read email and scan for specific values as input to a process within the program.

Select First Row Under The Header That Contains Data
How would i select the first row containing data under the header, after i have used an auto filter with the filter still on. Thanks

Returning MP? Header Data
G'day!

I was wondering if any of you Gurus has a code written in Visual Basic for returning MP?(MP3, MP2 and MP1) data like bit-rate, channel, emphasis... The code should handle VBR files correctly!

I have tested all the samples found on PSC and none of them work perfectly. Most of them had problems with VBR files and a few weren't able to return the copyright and original flags correctly.

Thanks!

Copy Filtered Data Without The Header
Hello...

Know it's simple... I can't do it... tried offsets, tried resizes, nothing seems to work!

Currently using a range offset that is taking the header with it...

Any help would be appreciated

Thanks

Header && Detail Data On A Form
Hi all, if I would like to put both header and detail data on the same form, what will be the best way to display the detail information (assuming that Header and detail is a one to many relationship). Thank you!

sasa

Data Report Group Header
Can the same be possible if we don't use DAtaenvironment. Means if we r not using dataenvironment and want to set group headers in datareports.

Data Report Group Header
I try to add group header section to my data report, but there is an error saying that 'report section don't match datasource', can anyone tell me the correct way to use this report section?

Data Report - Group Header
How do I use group header?
Once i insert a group header & footer.. it will prompt an error saying that "Report sections do not match data source".

What is the problem? Does it have anything to do with Data Member?

Thanks!

Dynamic Header Of Data Reports
I need to learn how I can assign dynamic values into label object on Report-Header-Section or Page-Header-Section of data reports instead of using fix label caption. Because I need the to get header description described in different ways depending on the situations. For example a value in a table or a counter in an application.

Any help will be appreciated.

Winsock - Sending Header With No Data
Hi all,
I am writing a VB6 app with using Winsock.

When connecting to the server, I need to send a header only with no data attached.

While using a Packet Monitor I have tried sending
tcpServer.SendData ""
or
tcpServer.SendData vbNullString
both with no joy! Sending these 2 lines actually does nothing at all, no header, no nothing!!

Anyone got an idea how this is done? If possible...
Thanks.

kaza007

Group Header In Data Report
Hi
I'm using vb 6.0.I am using data reports in vb to generate reports.I want to include group header.How to do that other than using shape command
Pls help me
Thnx
Nebu

Group Header - Data Report
I've got a data report that groups on a dept here, the only problem (that my boss found) is that the header needs to be printed on all pages, not just the group. Since I can't put the group header text fields in the page header, is there a way for me to get the group header to print on all pages?

Thanks!

Data From Excel To VB By Column Name/header
My users create Excel worksheets that have a single header row with the field name for each column's data. The fields are NEVER in the same columns from worksheet to worksheet.

How can I pull the data from all worksheets, using the field name in the first row, putting each column's data into it's corresponding recordset field?

Thanks for any tips!
UB

Data Report Group Header
hi guys! i hope anybody can help my problem using vb data report. My problem is, i want to re-print the group header on the next page if there are details left which is belong to the same group header. How can i resolve this problem, any help will be appriciated. Thanks!.

Copy Advanced Filter Data Without The Header
Hello All

I'm starting an advanced filter event from the "Completed Jobs" sheet.The following code works great but it brings the criteria header with each filter.

Code:
Sheets("Clean Sheet").[A1:E5000].AdvancedFilter Action:=2, CriteriaRange:=Sheets("Completed Jobs").[A1:E21], _
CopyToRange:=Sheets("Completed Jobs").[B65336].End(xlUp).Offset(1, 0)

What I'm doing is stacking daily information under the previous days data.
Is there any way to run this filter and copy the data without the header row?

Parameters In Page Header Of Data Report
Hi,

I have to pass some parameters do Data Report (of Visual Basic 6.0). I did. Further, I want the parameters to display along with the page header (or) report header.

For example, if I am sending two dates to the report and fetching the data between them. I want to display the report header or page header which reflecting that those data are between those two dates.

Like...XYZ REPORT FROM 10.JUN.2004 AND 16.JUN.2004

Expecting the solutions.

Bye,
Sridhar

Passing The Parameter To The Data Report Header
Dear Friends,

I have a form which contains 2 combo boxes

1. cmbMonth
2. cmbYear

I want to pass the text it contains to the Data Report Header

How to pass the parameter to the report header in Data Report ie cmbMonth.text & cmbYear.text

I want to use the above in the Account Credit Statement which i prepare on the monthly basis & I require to show the month in the report.

Pls help me,

Thanks,

Dennis.

Problem With Data Report Header Label...
Hi,
I want to display report by department.I've created form with data combo and button (for user to select which dept).
This is the code,
[/code]
Private Sub cmd_Preview_Click()
Dim dept As String
dept = DataComboDept

Report1.Sections("section4").Controls ("label12").Caption = "" & dept
Report1.Show
Unload Me
End Sub

Private Sub DataComboDept_Change()
If DataEnvironment1.rsCommand1.State Then _
DataEnvironment1.rsCommand1.Close

DataEnvironment1.Command3 DataComboDept.BoundText
cmd_Preview.Enabled = True
End Sub
[/code]

It works..but i need to close the form first so that i can make next selection. It means i can make 1 selection at 1 time, if not, error occurs, 'The operation requested by the application is not allowed if the object is open'.

Any idea? thanx..

Data Report Of Vb6 - Page Header Problem...
i have a report wherein some data in the page header section change everytime the value of a certain field changes...

example:
the data is grouped by batch#....

if batch# field's value = 001
the header becomes = 'RECEIPTS REGISTER'
if the value = 002
the header becomes = 'INVENTORY SUMMARY'
... AND so on....

the batch# is in the details section...
the header is in the page header section....

then, after every changes in batch# field, there is a page break...

how will i manipulate it? i am using vb6's data report... anybody help me out? i really need it badly....

Data Report - Repeat Group Header
Is there a way to repeat the group section if a group covers more than 1 page?

Adding Variables To A Data Report Header
Hello,
I have a fairly important issue. Does anyone knows how to add a variable into the report header of a data report?

Basically I have a small tracking application which produces a trail of transactions via the data reporting tool in VB. As a header I wanted something like:

"License Trail for Customer ...... "

the ...... should be the customer name, however I cannot see any way of adding a parameter to the header portion of the data report. I did try with a text box etc but the header area would not allow this control.

The documentation on the topic area appear to be sparse.

Thanks in advance.

Tony.

Data Report Crappy Section Header
Hi people, here's the problem
I have an access database with many a table in it, it's an employee information file, with an employee table that holds name and contact details for the employees, other tables hold absence, skill, conduct, and historical information, all tables have a key field "int_emp_code" which is used throughout the system, on data environment i have the primary connection and the employee as a child, then i have child commands underneath linking off the previous command, only the employee command (the top level command) is grouped, and the datasource for the data report i am having trouble with is the employee command.
now i have all my sections correct in this report and before people post NOT ONE thing on the report has a visible property of false, however the employees section shows and is correct, the same goes forsubsequent sections until i get to the final table in the hierarchy "Courses", this is simply a list of training courses, however the section will not display on the report. Even if i simply put a data label on there and set a dummy caption the field will not be displayed on the report, i have tried adding a child command to see if it happened because it was the lowest level command but it made no difference, please help as this is really becoming an issue now and as usual microsoft is about as usefull as the french armed forces

(Resolved)Group Header In Data Report
Hi all,
I am using Data Report and VB6.0. I have a table named DOC1 which consists of voucher No, Date, description, amt, etc.

I want to dislay voucher no in group header as voucherno is not unique. I have to calculate total amt of same voucher no i.e . i require to put the subtotal of amts for particular voucherno before start of next voucher no.

I want to create report without using data environment

I can generate simple report without using subtotals and placing voucherno in detail section instead of header section.

i have written code in one form that calls data report

The code is :

Dim strquery As String
Dim query As String
Dim rs1, rs2 As ADODB.Recordset

strquery = "Select D2_DNO,D2_DDT,D2_NARR, D2_DRCR, D2_AMT from DOC2 where D2_DDT between # " & txtFromDate.Text & "# and #" & txtToDate.Text & "# and D2_DIVCD = '" & txtCompCode.Text & "'"

Set rs = conn.Execute(strquery)
Set drptDetail.DataSource = rs

drptDetail.Sections("rptHeader").Controls("lblCurDtTime").Caption = DateTime.Now
drptDetail.Sections("rptHeader").Controls("lblDivCd").Caption = txtCompCode.Text
drptDetail.Sections("pgHeader").Controls("lblRunOn").Caption = DateTime.Date
drptDetail.Sections("pgHeader").Controls("lblFrom").Caption = txtFromDate.Text
drptDetail.Sections("pgHeader").Controls("lblTo").Caption = txtToDate.Text

Unload Me
drptDetail.Show

I m placing rptTexBoxes in report and binding their datafield with desired records of database.

But if i try to put textbox with datafield d2_DNO (this is voucher no field) in group header section it displays an error saying "Report sections does not match data source". Even, i m not allowed to insert group header and footer. I am new to report and i dont have much information related to it.

I cant understand how to do this.

Plz help me and send code for this. Its very urgent.

Thanks.

Edited by - Krupa Jetly on 8/29/2006 2:36:04 AM

Unable To Add In New Header/footer To Data Report
hi i have a problem here... i cant add addtional header/footer to my data report... i got this error : "data report section do not meet data source " ???????????? can help mi to solve this problem.. how this can be solve..

thanks a lots..

Add Group Header Section In Data Report
Hi guys,
       I'm trying to create report by using data report without data environment. I created reports before but they're like tabular reports which involve only Detail Section. Now, I try to add a group header section to show data as a group. I don't know if I did this wrong since start. So, I'd really appreciate if anyone can explain me how to do this.

Let's say that below is my table

Date Order Cost
-------------------------
xxx 1 10
xxx 2 15
xxx 3 10
yyy 1 12
yyy 2 10

I want to show Date in group header section, Order in detail section, and TotalCost in group footer section. What I did was I had these records stored in Recordset then set datamember and datafield as I did for tabular reports. It didn't work. It showed me a message error 'Reports sections do not match data source'. So, my main questions are
1. How can I refer group header section or even add higher level to the report to my data?
2. How can I add function to the report at the end of each section?

Below is how the report should look like

========================
Date Order Cost
========================
xxx
                                   1 10
                                   2 15
                                   3 10
-----------------------------------------
                       Sub-Total 35
------------------------------------------
yyy
                                   1 12
                                   2 10
-----------------------------------------
                       Sub-Total 22
=======================
                              Total 57
=======================

Thank you so much in advance for any suggestion.

Problem With Data Report Header Label...
Hi,
I want to display report by department.I've created form with data combo and button (for user to select which dept).
This is the code,

Code:Private Sub cmd_Preview_Click()
Dim dept As String
dept = DataComboDept.Text

Report1.Sections("section4").Controls ("label12").Caption = "" & dept
Report1.Show
Unload Me
End Sub

Private Sub DataComboDept_Change()
If DataEnvironment1.rsCommand1.State Then _
DataEnvironment1.rsCommand1.Close

DataEnvironment1.Command3 DataComboDept.BoundText
cmd_Preview.Enabled = True
End Sub

It works..but i need to close the form first so that i can make next selection. It means i can make 1 selection at 1 time, if not, error occurs, 'The operation requested by the application is not allowed if the object is open'.

Any idea? thanx..

Problem With Label On Data Report Header..
Hi..
I'm using access dbase and i have month (text data type) and year (integer data type) on table. I have ComboMonth and ComboYear on frmInput. I've created data report and i want the month and year appear on the header. This is the code,

Code:Private Sub DataReport_Initialize()
Dim var_month As String
Dim var_year As Integer

var_month = frmInput.ComboMonth.Text
var_year = frmInput.ComboYear.Text

DataReport1.Sections("section2").Controls("label16").Caption = "Report summary for"
DataReport1.Sections("Section2").Controls("Label12").Caption = " Month " & var_month
DataReport1.Sections("Section2").Controls("Label13").Caption = " Year " & var_year
End Sub

When i run the data report, both month and year didn't appear..any idea? i think it is because of the combo box..if i'm using text box..it should not be a problem.

tq..

One Of The Field As A Page Header Of Data Report
In order to avoid repetition of printing of a same information , I want to use that field as a page header of the data report. I tried to place that fields in page header section but I failed. Pls any one of u gurus out there help me.

Thanks Premlatha for helping me. I was badly stuck in this. B'cos my client was insisting to avoid duplicate printing. Thanks to u for helping me in fulfilling this requirement.

Data Report (Want To Print Table Contents In Header)
Hello,

I want to print the data retrieved from one field of a table only once in the report header or page header.

Data report is not allowing me to do this.

I have one form with one combobox and textbox. where i take the input from the user for month & year. According to that i show all the entries of that month & year in data report but i want to print the value taken in combobox & textbox in my report at top. eg.

XYZ Company
'January 2004'

only once in header.

Can i do it.

Thaking in anticipation.

Regards.

Getting Header And Sending Data Through Multiple Sockets With Winsock
Hi everyone, I am looking to open up multiple winsock connections and send data to a web server.

I am only familiar with Inet and winsock seems complicated. Can anyone instrict me on how to get started? Also, i need help getting the header of a server. Thanks!

~Tw1nChromeGlocks

REPEATING THE GROUP HEADER SECTION IN THE VB DATA REPORT
Anyone can tell me repeating the Group Head Section in each page.

Regards
Arun

Placing A Bound Field In The Data Report Header
i need to display the year for a report in the data report header. the year is in the recordset. how can i do this

pls help

Edited by - Shandy on 4/22/2004 8:57:14 PM

Printing Header Info Beside Detail Data With DataReports
Dear Friends,

I am glad I stumbled onto this site. It looks like there are a lot of folks here who can help me when I get stuck. Maybe I can help others with some of the stuff I know, too.

I would like to be able to put the "header" information on the same line as the "detail" information in a report using DataReports. For example, I have a couple of tables "Payments" and "Disbursements" with a one to many relationship. Say that $200 comes in for a payment and we disburse $150 to one person and $50 to another. My history report now looks like this:

10/1/03 Payment: 200.00
    150.00 Check for Joe
     50.00 Check for Jane
11/1/03 Payment: 200.00
    150.00 Check for Joe
     50.00 Check for Jane

I'd like it to look like this:

10/1/03 Payment: 200.00 150.00 Check for Joe
                         50.00 Check for Jane
11/1/03 Payment: 200.00 150.00 Check for Joe
                         50.00 Check for Jane

I put the Payment and Disbursement history tables temporarily in an Access database, then use a view to join them. I am using the DataEnvironment and DataReports, but I am open to any other suggestions on how to do this.

Any ideas?

Thanx,

jay

How To Change The Header Label Of Data Report In The Vb Program?
Hi,
How to change the header label of data report in the vb program?

thanks

How Do I Display Data In Page Header Section In VB Report Designer
Hi there,
I have tried to display some data in lable in Page Header section of VB Report Designer but I could not get them to work.
ex:
Private Sub DataReport_Activate()
   lblDate.Caption = Date

   lblSerialnumber.Caption = "9999"
End Sub
Any advice will be Appreciated.

regards,

Datareport (Report Header && Page Header)
Hello,

I want to show & print company's name & address on the first page of the report & only company's name on remaining pages.

How it can be done.

On first page -
XYZ co
xyz road, etc

On remaining pages -
XYZ co

Thanking in anticipation.

Regards.

Data Is Coming Correctly In Report, But Date In The Date Header Is Not Refreshing Help Pls
Hai

I am dispalying the report from VB. the data is showing correctly as per the parameter I pass from VB. But the formula box in the PagerHeader in Crystal report , some times misses the correct date and show the previous date (i.e) the previous parameter passed by the user. But the data is shown correctly.

The below is the command button event

Private Sub cmdpPreview_Click()
On Error Resume Next
    If optProduct.Value = True Then
       Call PCsumListbyValue
    ElseIf optItem.Value = True Then
        Call optPItemwise
    Else
        MsgBox "Choose Option !", vbExclamation, "Option - Missing"
    End If
End Sub

The below is the code in the function

Private Sub PCsumListbyValue()

CrystalReport1.Formulas(1) = " "
CrystalReport1.Formulas(4) = " "
CrystalReport1.GroupSelectionFormula = " "
pfdt = txtpfrom.Text
ptdt = txtpto.Text
If Len(cmbPprod.Text) <= 0 Or cmbPprod.Text = "All" Then
   CrystalReport1.ReportFileName = App.Path & "cstlistvaluewgt.rpt"
   strsf = "{Sales.SoldDate} in Date(" & _
   Format(pfdt, "YYYY,M,D") & ") to Date(" & _
   Format(ptdt, "YYYY,M,D") & ")"
   CrystalReport1.ReplaceSelectionFormula (strsf)
   CrystalReport1.Formulas(1) = "fdt='" & pfdt & "'"
   CrystalReport1.Formulas(4) = "tdt='" & ptdt & "'"
   CrystalReport1.DiscardSavedData = True
   CrystalReport1.PrintReport
Else
   CrystalReport1.ReportFileName = App.Path & "cstlistvalue.rpt"
   strsf = "{Sales.SoldDate} in Date(" & _
   Format(pfdt, "YYYY,M,D") & ") to Date(" & _
   Format(ptdt, "YYYY,M,D") & ")"
   CrystalReport1.ReplaceSelectionFormula (strsf)
   CrystalReport1.GroupSelectionFormula = "{Sales.Product}='" & cmbPprod.Text & "'"
   CrystalReport1.Formulas(1) = "fdt='" & pfdt & "'"
   CrystalReport1.Formulas(4) = "tdt='" & ptdt & "'"
   CrystalReport1.DiscardSavedData = True
   CrystalReport1.PrintReport
End If
End Sub

i tried by ticking the check box in the File menu --> Option --> Reporting Tab --> [Discard Saved Date while loading Report] and also I tried by uncheck the box [Save Date With Repot]. Then also its not working.

I also attached the front view of the form. Kinldy view and reply me.

Thank you very much,
Chock.

Thank you very much,
Chock.
itchocks@rediffmail.com

<HTML>
<B><font color="#008000">HAVE A NICE DAY !</font></B>
<HTML>

Edited by - chs on 5/24/2003 9:51:07 AM

URGENT: Data Report (Page Header On Each Page)
Hi,

I am using Data Report (why?!!) to print a bill. It contains the company name and other information such as date and total amount etc.

I am doing this by coding only. NO DATA ENVIRONMENT (!).

I have put a lable on the Page header and I am displaying the company name in that lable. It prints perfactly on the first page of the bill. But it does not appear on the second page of the bill. Instead it displays the remaining items of the bill from the beginning.

I want to print company name on each page of the bill. this is shown in the image.

Is there a way to get the out put like this?

Please help me. Its urgent.

Thank a ton in advance.

Urgent Help - Report Header On Data Report
Someone please help me. I need to programatically place information like this on my report header:

"Report printed on"& Date & "By " & name

"name" is a data from a field in an access table.

email: jayeni@iflnig.com

tanks

Emails
can somone tell me were i can get some good reading mat. on how to use outlook to send emails. i have never done this and have no clue

Emails
how do i send the email as it seems that it just goes into the outbox in outlook the code i am using is

Code:
Public Function SendEmail()
On Error GoTo EmailError
With MAPISession1
.DownLoadMail = False
.LogonUI = True
.SignOn
.NewSession = True
MAPIMessages1.SessionID = .SessionID
End With
With MAPIMessages1
.Compose
.RecipAddress = Trim$(txtTo.Text)
.AddressResolveUI = True
.ResolveName
.MsgSubject = txtSubject.Text
.MsgNoteText = rtbEmail
.Send
End With
MsgBox ("Message sent")
Unload Me
frmMainPage.Show
EmailError:
End Function