Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sendin reports via e-mail

Status
Not open for further replies.

cmptrnerd

IS-IT--Management
Aug 11, 2001
255
US
What is best method of sending e-mails or sending e-mails with attachments with Foxpro.

Mark
 
I don't know what's BEST, but our local FoxPro group has been doing some work on using Outlook to send e-mail. In particular Outlook 2000.

Here's code from a program just to show you what using Outlook via code looks like:
Code:
release all LIKE 'ded*'
* clear all
LOCAL CurItem, NewItem
USE inmail
GO BOTTOM
NewItem = messageno + 1
? newitem
 dedOlApp = CREATEOBJECT("Outlook.Application")
 dedNameSpace = dedOlApp.GetNameSpace("MAPI")
 dedFolder = dedNameSpace.GetDefaultFolder(6)
 
 FOR CurItem = NewItem TO dedfolder.items.count
  	dedMailIn = dedfolder.items(CurItem)
 	WITH dedMailIn
 		INSERT INTO	inmail;
 			VALUES (NewItem, .subject, .Body, .to, .cc, .bcc, .receivedtime, .sendername)
 	ENDWITH
 	NewItem = NewItem +1
 ENDFOR
Can't remember exactly what this one does (I think it puts incoming mail into a foxpro database), but it shows how to create an Outlook object and do things with it.

Dave Dardinger
 
From this forum, select search and enter "Sending Email". You will get about 20 different ideas/ways of doing it. David W. Grewe
Dave@internationalbid.com
 
Hi
Have a reading in
How can I send an Email using OUTLOOK from VFP?
faq184-766
Hope this helps

ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top