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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print to Email from custom screen not working

Status
Not open for further replies.

vbdbcoder

Programmer
Nov 23, 2006
247
US
Hi,

I am having problem with printing to email from a custom OE screen. Would you please provide some guidance. :)

Below is the details:

Sage 300 Version is 2017 PU2. Sage 300 is configured to use Email as "Print Destination".

The custom screen was written in VB 6.0 with OE OCX. It has survived the last 2 upgrades with the same code. It has a couple small additional functions, e.g. create items on the fly, create vendor cost. The Post button has a few updates that are not relevant to Sage 300 data, and it calls "vPost.Value = True" to use Sage 300 native post routine to get the data to Sage 300. When it is supposed to pull the client email software and attach the OECONF01.pdf in the email, it gives an error "Mail delivery failed. Use the Email tab on the Company Profile screen to send a test email and confirm that all settings are correct.".

I tried the settings in the Email tab in company profile screen in CS. I am not sure what I missed here. I entered Google SMTP settings or my own company settings. It did not send the Test Email. I am not sure if this is related. Or... I might need an additional DLL in the application folder. (I have to copy "a4wcrInterop.dll" to my application folder in order to print preview the crystal, which leads me to think I might need a DLL to fix.)

Native Sage 300 OE screen launches the client email software, e.g. outlook, and attaches the pdf file in the email. The uses will need to fill in the email address and send it out. That part works fine.

Best Regards,


 
You might need to run process monitor to see what the custom screen is unable find. That would confirm that the DLL issue you suspect is the case.

As an alternative you could write code to send the email yourself.
 
DjangMan,

Thanks for the response. I could get it to work. As long as Company Profile -> Email tab can send a test email. The custom OE screen will prompt a screen to enter email's sender, subject, email content, and send the document in attachment from there. The email screen is simple and the local email client won't be launched. That means Email can be sent without local email software.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top