By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Stop attachments from accumulating

P: 1
Hello - this is my 1st question.

I have created an Access database that pushes emails with attachments (should be 1 attachment per email). My attachments are accumulating rather than 1 attachment per email. So, if there are 3 people who should receive an email, the 1st one gets 1 attachment (that is right), the 2nd gets 2 attachments (the 1st one and the 2nd one) and the 3 person gets all 3 attachments.

How do I prevent this? Here is the code I am using:

'Prep and send e-mail
vEmailBody = Replace(vTemplateEmailBody, "[RM_NAME]", sPrevRelMgr)
.HTMLBody = vEmailBody
.Subject = Forms![Push Emails Menu]!txt_subject_step6.Value
.addattachment sSpreadsheetFilePath + sPrevRelMgrEmail + ".xls"
.To = sPrevRelMgrEmail
.Sender = sPrevRelMgrEmail

email_ctr = email_ctr + 1
Apr 28 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.