Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

OLE Object WInFax Pro (Send Excel File)

2 posts in Objects Last posting was on 2002-07-27 04:17:54.0Z
Gary Lam Posted on 2002-07-20 04:19:27.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Gary Lam" <garylam@midland.com.hk>
Subject: OLE Object WInFax Pro (Send Excel File)
Date: Sat, 20 Jul 2002 12:19:27 +0800
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
NNTP-Posting-Host: 210.177.115.250
Message-ID: <364_USu5fY6LCHA.196@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:1089
Article PK: 713658

Dear All,

Can WinFaxPro (OLE Object) send excel files?? Code Sample is welcome!!

Thanks,
Gary Lam


Edward Muesch Posted on 2002-07-27 04:17:54.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Edward Muesch" <emuesch_AT_hotmail_DOT_com>
Subject: Re: OLE Object WInFax Pro (Send Excel File)
Date: Sat, 27 Jul 2002 00:17:54 -0400
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: vzw-166-152-11-145.airbridge.net 166.152.11.145
Message-ID: <364_aNcv$ZSNCHA.395@forums.sybase.com>
References: <364_USu5fY6LCHA.196@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:1067
Article PK: 713629

Yes, it is possible. However, whether or not you want to have WinFax take
care of calling on Excel to print it to the WinFax printer or you want to
use Excel OLE automation to do this is up to you. In any case, you should
go through the WinFax documentation to learn the ins-and-outs of faxing
documents using OLE automation before getting in too deep. Remember, this
isn't as easy as e-mail and the considerations are many.

Here is a sample from a post using WinFax 9.0 OLE automation in Powerbuilder
back in 1999.

--- Begin Sample ---

OLEObject ole_winfax
str_recipient istr_recipient[]

/* For all files to be faxed perform the following. */
/*Create the winfax object*/
ole_winfax = CREATE OLEObject
li_olerc = ole_winfax.ConnectToNewObject("winfax.sdksend")

/*Set Fax Properties*/
ole_winfax.setcoverfile("u:\systems\lr_email\Basic1.cvp")
ole_winfax.setcovertext('CDS List Rental Nightly Reports are attached.')
ole_winfax.setdate(string(Today(), "mm/dd/yy"))
ole_winfax.settime(string(Now()))
ole_winfax.setsubject("Nightly Reports")
/*Add the new file as the file attachment. */
ole_winfax.addattachmentfile(is_path + is_FileName)

/* add the first recipient */
ole_winfax.setareacode(istr_recipient[1].areacode)
ole_winfax.setnumber(istr_recipient[1].number)
ole_winfax.setcompany(istr_recipient[1].company)
ole_winfax.setto(istr_recipient[1].name)
ole_winfax.addrecipient()
/* add the second recipient */
ole_winfax.setareacode(istr_recipient[2].areacode)
ole_winfax.setnumber(istr_recipient[2].number)
ole_winfax.setcompany(istr_recipient[2].company)
ole_winfax.setto(istr_recipient[2].name)
ole_winfax.addrecipient()
/* repeat as many times as you want ..... */

ole_winfax.send(0)
ole_winfax.done()
DESTROY ole_winfax

--- End Sample ---

HTH

-EGM

"Gary Lam" <garylam@midland.com.hk> wrote in message
news:USu5fY6LCHA.196@forums.sybase.com...
> Dear All,
>
> Can WinFaxPro (OLE Object) send excel files?? Code Sample is welcome!!
>
> Thanks,
> Gary Lam
>
>