| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I save multiple email attachments using excel automatically?
Hi,
Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automatically?
Hi Chris
For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
Hi Ron,
Thank you so much for getting back to me. I'll try the code out and let you know how I get on. P.S I use Outlook Regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
Ron,
I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
The only problem is that this code just moves the email within outlook. I
really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
Yes,
Maybe it's me that's being a bit thick! This what I've got in my code where I believe it does the searching and copying and pasting: Set MoveToFldr = Fldr.Folders("Acks") ------I Believe this is the folder it moves the email to in outlook------- MyPath = "C:\Documents and Settings\Chris\My Documents\Acknowledgements" -----I believe the folder where it should save the attachment to in my C Drive------ For i = Fldr.Items.Count To 1 Step -1 Set olMi = Fldr.Items(i) If InStr(1, olMi.Subject, "14") 0 Then -------I believe this is where you indicate what to look for in the subject--------- For Each olAtt In olMi.Attachments If olAtt.Filename = "AckReport.csv" Then -----I believe this is the name of the email attachment--------- olAtt.SaveAsFile MyPath & olMi.SenderName & ".csv" -----I believe this how it saves the email attachment--------- Thanks and regards Chris "Ron de Bruin" wrote: The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
Add a slash
MyPath = "C:\Documents and Settings\Chris\My Documents\Acknowledgements" Change to MyPath = "C:\Documents and Settings\Chris\My Documents\Acknowledgements\" -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Yes, Maybe it's me that's being a bit thick! This what I've got in my code where I believe it does the searching and copying and pasting: Set MoveToFldr = Fldr.Folders("Acks") ------I Believe this is the folder it moves the email to in outlook------- MyPath = "C:\Documents and Settings\Chris\My Documents\Acknowledgements" -----I believe the folder where it should save the attachment to in my C Drive------ For i = Fldr.Items.Count To 1 Step -1 Set olMi = Fldr.Items(i) If InStr(1, olMi.Subject, "14") 0 Then -------I believe this is where you indicate what to look for in the subject--------- For Each olAtt In olMi.Attachments If olAtt.Filename = "AckReport.csv" Then -----I believe this is the name of the email attachment--------- olAtt.SaveAsFile MyPath & olMi.SenderName & ".csv" -----I believe this how it saves the email attachment--------- Thanks and regards Chris "Ron de Bruin" wrote: The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
Ron,
I have tried to reply, but the pages seem a bit hit and miss to whether they work or not. Anyway I'll try again! I've managed to get the coding to work!!!! The only problem is that because the attachments and sender are the same in all of the emails it only seems to copy one of the emails to my C drive. Is there anyway that can think of please what else I could use in the email to seperate them? Thanks very much Ron Chris "Ron de Bruin" wrote: The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
Try to add the time to the file name
olAtt.SaveAsFile MyPath & olMi.SenderName & olMi.ReceivedTime & ".xls" Can't test it for you but try this one -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I have tried to reply, but the pages seem a bit hit and miss to whether they work or not. Anyway I'll try again! I've managed to get the coding to work!!!! The only problem is that because the attachments and sender are the same in all of the emails it only seems to copy one of the emails to my C drive. Is there anyway that can think of please what else I could use in the email to seperate them? Thanks very much Ron Chris "Ron de Bruin" wrote: The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
Ron, you're a star!
Works a treat, thanks so very much for your time and trouble. Really is appreciated. Many thanks Chris "Ron de Bruin" wrote: Try to add the time to the file name olAtt.SaveAsFile MyPath & olMi.SenderName & olMi.ReceivedTime & ".xls" Can't test it for you but try this one -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I have tried to reply, but the pages seem a bit hit and miss to whether they work or not. Anyway I'll try again! I've managed to get the coding to work!!!! The only problem is that because the attachments and sender are the same in all of the emails it only seems to copy one of the emails to my C drive. Is there anyway that can think of please what else I could use in the email to seperate them? Thanks very much Ron Chris "Ron de Bruin" wrote: The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
You are welcome
Thanks for the feedback -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, you're a star! Works a treat, thanks so very much for your time and trouble. Really is appreciated. Many thanks Chris "Ron de Bruin" wrote: Try to add the time to the file name olAtt.SaveAsFile MyPath & olMi.SenderName & olMi.ReceivedTime & ".xls" Can't test it for you but try this one -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I have tried to reply, but the pages seem a bit hit and miss to whether they work or not. Anyway I'll try again! I've managed to get the coding to work!!!! The only problem is that because the attachments and sender are the same in all of the emails it only seems to copy one of the emails to my C drive. Is there anyway that can think of please what else I could use in the email to seperate them? Thanks very much Ron Chris "Ron de Bruin" wrote: The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
After testing
Use this instead, it blow on my system because i use / in the date on my system Use the format function to change it to - olAtt.SaveAsFile MyPath & olMi.SenderName & " " & Format(olMi.ReceivedTime, "dd-mmm-yy hh-mm-ss") & ".xls" -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... You are welcome Thanks for the feedback -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, you're a star! Works a treat, thanks so very much for your time and trouble. Really is appreciated. Many thanks Chris "Ron de Bruin" wrote: Try to add the time to the file name olAtt.SaveAsFile MyPath & olMi.SenderName & olMi.ReceivedTime & ".xls" Can't test it for you but try this one -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I have tried to reply, but the pages seem a bit hit and miss to whether they work or not. Anyway I'll try again! I've managed to get the coding to work!!!! The only problem is that because the attachments and sender are the same in all of the emails it only seems to copy one of the emails to my C drive. Is there anyway that can think of please what else I could use in the email to seperate them? Thanks very much Ron Chris "Ron de Bruin" wrote: The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
Another option :
Maybe this is better olAtt.SaveAsFile MyPath & olMi.SenderName & " " & i & ".xls" No problem if the ReceivedTime is the same(you never now) If you want to merge the data you can look here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... After testing Use this instead, it blow on my system because i use / in the date on my system Use the format function to change it to - olAtt.SaveAsFile MyPath & olMi.SenderName & " " & Format(olMi.ReceivedTime, "dd-mmm-yy hh-mm-ss") & ".xls" -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... You are welcome Thanks for the feedback -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, you're a star! Works a treat, thanks so very much for your time and trouble. Really is appreciated. Many thanks Chris "Ron de Bruin" wrote: Try to add the time to the file name olAtt.SaveAsFile MyPath & olMi.SenderName & olMi.ReceivedTime & ".xls" Can't test it for you but try this one -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I have tried to reply, but the pages seem a bit hit and miss to whether they work or not. Anyway I'll try again! I've managed to get the coding to work!!!! The only problem is that because the attachments and sender are the same in all of the emails it only seems to copy one of the emails to my C drive. Is there anyway that can think of please what else I could use in the email to seperate them? Thanks very much Ron Chris "Ron de Bruin" wrote: The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
|
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I save multiple email attachments using excel automaticall
Ron,
Yeah I see what you've mean. I've played around with the coding a little bit more to refine it, it's brilliant. My system too was bombing when I pointed the code to look at the subject, so I am now using file size. Thanks once again for your time Regards Chris "Ron de Bruin" wrote: Another option : Maybe this is better olAtt.SaveAsFile MyPath & olMi.SenderName & " " & i & ".xls" No problem if the ReceivedTime is the same(you never now) If you want to merge the data you can look here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... After testing Use this instead, it blow on my system because i use / in the date on my system Use the format function to change it to - olAtt.SaveAsFile MyPath & olMi.SenderName & " " & Format(olMi.ReceivedTime, "dd-mmm-yy hh-mm-ss") & ".xls" -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... You are welcome Thanks for the feedback -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, you're a star! Works a treat, thanks so very much for your time and trouble. Really is appreciated. Many thanks Chris "Ron de Bruin" wrote: Try to add the time to the file name olAtt.SaveAsFile MyPath & olMi.SenderName & olMi.ReceivedTime & ".xls" Can't test it for you but try this one -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I have tried to reply, but the pages seem a bit hit and miss to whether they work or not. Anyway I'll try again! I've managed to get the coding to work!!!! The only problem is that because the attachments and sender are the same in all of the emails it only seems to copy one of the emails to my C drive. Is there anyway that can think of please what else I could use in the email to seperate them? Thanks very much Ron Chris "Ron de Bruin" wrote: The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder Have you test this one http://www.dicks-clicks.com/excel/ol...ve_Attachments -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Ron, I've tried the coding and it works great. The only problem is that this code just moves the email within outlook. I really need the code to find the attachment and save it to a folder on my Z drive at work i.e out of Outlook completely. As it saves the email I need the attachment to be saved adding something unique to the filename because when I receive the emails the attachments are all called the same. The other option I see I have is to drag and drop the emails into my Z drive then then automatcially strip the attachments out as explained above. Any Ideas? Thanks and regards Chris "Ron de Bruin" wrote: Hi Chris For Outlook see http://www.dicks-clicks.com/excel/olRetrieving.htm Or do you use OE? -- Regards Ron de Bruin http://www.rondebruin.nl "ir26121973" wrote in message ... Hi, Wonder if somone can help me out please. I am very new to VB, but willing to learn. I receive up to 900 emails a day. All have one attachment in a .csv format and all are attachments are called Ack. I am desperately trying to find some code where I can automatically take the email attachments without opening the email and save them to a shared folder where they are saved using the email subject as the filename. The problem I have got is that the functionality for using VB in Outlook has been taken away from the computer system at work so the only VB I can use is through Excel. Because of this I am not sure whether it i easier to drag and drop the emails from outlook into the shared folder and then extract from there. I really would appreciate some help here, because I am under quite a tight deadline. Many thanks in advance Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot open 2007 excel files(.xls) as email attachments on Win. Vi | Excel Discussion (Misc queries) | |||
| OPENING EXCEL EMAIL ATTACHMENTS | Excel Discussion (Misc queries) | |||
| Excel email attachments print differently for each user, why? | Excel Discussion (Misc queries) | |||
| Email merging Excel attachments | Excel Discussion (Misc queries) | |||
Linear Mode
