I am trying to import an excel file into the body of an automated mail, currently I am saving the excel file as a text file and importing line by line(see below), is their anyway of importing directly from excel?
Set doc = New NotesDocument( db )
Set rtitem = New NotesRichTextItem( doc, "Body" )
FileNum = Freefile()
FileName = "C:\latest Stock Prices.txt"
Open FileName For Input As FileNum
Do While Not Eof(FileNum)
Line Input #fileNum, oneLine
Call rtitem.AppendText( oneLine )
Call rtitem.AddNewLine( 1 )
oneLine = ""
doc.Form = "Memo"