Community Discussions and Support
Getting data from Microsoft Access into Pegasus

I'm helping an organisation that uses both Pegasus (4.41) and MS Access

2003 and they want to export emails from Access for use in Pegasus. 

They could run a query and then copy and paste results, but they want

something more automated.  It looks like is should be possible to write

an access script that writes out emails to a PML file.  Are there any

problems with generating those outside Pegasus and then dropping into

the mailing list directory?

If these PML files are RFC 2822 message files you use the CNM file extension instead you can drop these into the WinPmail new mail directory to do the transfer.

 

<blockquote>I'm helping an organisation that uses both Pegasus (4.41) and MS Access 2003 and they want to export emails from Access for use in Pegasus.  They could run a query and then copy and paste results, but they want something more automated.  It looks like is should be possible to write an access script that writes out emails to a PML file.  Are there any problems with generating those outside Pegasus and then dropping into the mailing list directory?</blockquote><p>If these PML files are RFC 2822 message files you use the CNM file extension instead you can drop these into the WinPmail new mail directory to do the transfer.</p><p> </p>

hi

I'm helping an organisation that uses both Pegasus (4.41) and MS Access 2003 and they want to export emails from Access for use in Pegasus.  They could run a query and then copy and paste results, but they want something more automated.  It looks like is should be possible to write an access script that writes out emails to a PML file.  Are there any problems with generating those outside Pegasus and then dropping into the mailing list directory?

Does anyone have other ideas about how this might be done?

Thanks.

steve

<P>hi</P> <P>I'm helping an organisation that uses both Pegasus (4.41) and MS Access 2003 and they want to export emails from Access for use in Pegasus.  They could run a query and then copy and paste results, but they want something more automated.  It looks like is should be possible to write an access script that writes out emails to a PML file.  Are there any problems with generating those outside Pegasus and then dropping into the mailing list directory?</P> <P>Does anyone have other ideas about how this might be done?</P> <P>Thanks.</P> <P>steve</P>
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft