I
idbr
Guest
Hi there, who fancies helping the new guy? 
I'm having a bit of a problem with Groupwise automation. I have a need to email a list of people and attach a different file for each individual. e.g
John Smith gets File1.xls
Tom Jones gets File2.xls etc, etc...
The recipient's name and email address are held in an Access table, tblMailList, in fields 'Recipient' & 'Mail' respectively. The attachments are created by a seperate routine and named by appending the recipient name to a standard stem, e.g
Filename = Path & "File " & [Recipient] & ".xls"
I've simplified things a bit for clarity.
Basically I want to loop through tblMailList, creating a new mail item for each value of [Recipient], attaching 'Filename' and sending to [Mail]. I'll also need to add body text and subject lines which incorporate string variables. I can handle everything except the Groupwise bit.
I'm using A97 on NT4 with GW5.
I'm an intermediate VBA user, but a novice with Groupwise so any help would be greatly appreciated.
Thanks, Iain
I'm having a bit of a problem with Groupwise automation. I have a need to email a list of people and attach a different file for each individual. e.g
John Smith gets File1.xls
Tom Jones gets File2.xls etc, etc...
The recipient's name and email address are held in an Access table, tblMailList, in fields 'Recipient' & 'Mail' respectively. The attachments are created by a seperate routine and named by appending the recipient name to a standard stem, e.g
Filename = Path & "File " & [Recipient] & ".xls"
I've simplified things a bit for clarity.
Basically I want to loop through tblMailList, creating a new mail item for each value of [Recipient], attaching 'Filename' and sending to [Mail]. I'll also need to add body text and subject lines which incorporate string variables. I can handle everything except the Groupwise bit.
I'm using A97 on NT4 with GW5.
I'm an intermediate VBA user, but a novice with Groupwise so any help would be greatly appreciated.
Thanks, Iain
