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

Need a work-around for sending .zip attachment in Access 2010.

P: 57
Hello,

Does anyone have a work-around into sending emails with .zip attachment? The code below doesn't seem to work and I need to attach .zip files.

Thanks.

Expand|Select|Wrap|Line Numbers
  1. objMail.Attachments.Add "c:\location.zip"
Feb 13 '15 #1
Share this Question
Share on Google+
3 Replies


jforbes
Expert 100+
P: 1,107
Are you getting an error? Or is your is your Mail Server stripping the .Zip file?

Many Mail Servers will strip off email attachment with out reservation if they could be even remotely be dangerous. Especially if they have an extension of .Zip. Try renaming the file extension and resending or replacing the period with an underscore.
Feb 13 '15 #2

P: 57
Outlook is stripping the file. The receiver of the file wouldn't know how to open it though or will it open in the same way?
Feb 13 '15 #3

jforbes
Expert 100+
P: 1,107
You'll have to determine how you will want to handle this.

You could talk to your IT Department and see if there is a way to allow your emails to go through with a .Zip extension, but your recipient's email server could strip the attachment and you will have no control over that.

You could copy the .Zip to your Web Server, FTP Server, or a Server on the Web and then send the link to the end user. Probably the preferred method as it puts the onus on the user.

You could rename the .Zip extension with something Email Server friendly like _Zip or .dat (maybe) and then include instructions in the email on how to save the attachment and rename at the same time.

You could send the contents of the .Zip as individual files and hope that the contents doesn't contain a red flag.
Feb 14 '15 #4

Post your reply

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