YuffieLM
Last Activity: Aug 16 '13, 07:47 AM
Joined: Aug 15 '13
Location:
-
Thank you for your help I'll try that now! :) -
Hi,
Thanks for that. I have Excel 2010 but I'm still on Access 2003 so my issue is getting Access to recognise the file rather than Excel. If that makes sense! I want to automate the process so that the file goes straight from my email into Access ideally.Leave a comment:
-
VB to save an xlsx outlook attachment as an xls file
I am very new to VB and have a simple code in Outlook to save my attachments from Outlook to the drive. I want to link them in Access from the drive but the files are sent in xlsx format and I have Access 2003. So can I edit my Outlook code to save the attachment in xls format?
Here is the code:
...Code:Public Sub saveAttachtoDisk(itm As Outlook.MailItem) Dim objAtt As Outlook.Attachment Dim saveFolder
No activity results to display
Leave a comment: