Hi,
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'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. Feel free to tell me if this should be an Access forum post.
Thanks, Iain
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'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. Feel free to tell me if this should be an Access forum post.
Thanks, Iain