I am trying to import a list of outlook items into excel. These items are found in a folder somewhere within the vast network that is my organisations mail folder structure.
In my Outlook this folder structure looks something like this:
Myname@mycompany.com
- Inbox
- - Sub Folder
- Drafts
- Sent Items
Othername@mycompany.com
- Inbox
- - Sub Folder
- Drafts
- Sent Items
[code].....
What I've got: This code allows the user to pick one (sub)folder - the MailItem properties of the folder are then printed to the sheet.
[Code] .....
My goal: Rather than allowing the user to pick one folder, I'd like to set up a hardcoded array of five subfolders found in a shared inbox. The hierarchy is as follows:
[Code] .....
The thing is, I have huge problems with referring to any of the red subfolders above. I think I'm able to point to the shared inbox if I substitute .Pickfolder with this, but then I'm stuck! I need to go down two levels in the hierarchy.
[Code] ......
I should be able to produce an array by myself so if I at least just could get a pointer on how to refer to one single folder that would be truly awesome.
I'm trying to identify a way of setting up a booking system for some meeting rooms we have at work. Always looking for a way of simplifying something that soaks up one of my colleagues time.
I read this post about a golf booking system and it looks like it could be adapted to suit, I can imagine a different worksheet for each room and the fields for entry on choosing the timeslot being the meeting title, who booked and a contact number and the slot showing the meeting name when hovered over possibly.
I noticed a similar thread about Outlook, I know nothing about this sort of stuff within Outlook and not sure it may be possible. I am just in my infancy with hyperlinks and macros and do not feel confident enough to start there as I do not know where to begin. Keen to learn and would love to figure out and play around within a program; learn best this way.
I'm currently using Ron's BuildToHTML Coding in "Example 1" (as can be seen here: [Code] ....... ) but I'm unable to tweek the coding to paste multiple ranges into the same outlook body.
For clarification, I have 2 charts in different tabs: Sales & Purchases. Following Ron's code I can change the coding so it copies Sales but I am unable to code the macro to paste the Purchases chart in the same outlook directly below Sales.
Sub Mail_Selection_Range_Outlook_Body()
' Don't forget to copy the function RangetoHTML in the module.
' Working in Office 2000-2010
Dim rng As Range
Dim OutApp As Object
Dim OutMail As Object
[code].....
I currently have a spreadsheet setup on a Macro to send & distribute a message from an 2007 Excel file to multiple users through Microsoft Outlook 2007. It is currently setup to send as an attachment. I need to find a way to have this file be sent as a PDF file. I know you can save Excel as PDF's so there must be a way to send them & attach them to as a PDF.
View 3 Replies View RelatedI'm programing a VBA macro in Outlook 2007. I have added a button to the quick bar so when i open an email and push that button, a Excel file opens and i can input some data. Thing is, i need that if the opened email have some kind of attachment, when i push the button i want this attachement to be saved into a specific folder. Is that posssible?
View 2 Replies View RelatedI need a macro which will copy an image from a folder location and paste it into a mail (outlook).
I don't want the image to be added as an attachment.
To search the users signature folder for Microsoft Outlook see if the have any .htm files, if so list them in a message
Make the print find the default printer work out if it is black and white or colour and find the nearest opposite printer. i.e. if default is colour find nearest black and white
Protect a sheet but allow tabbing from certain cells to others.
Enable the users to use the workbook without having to rely on their macro settings being Low.
I was able to create a macro that saves an email attachment based on the subject and then move it to another folder. I would like changing it to do the same thing only based one the sender’s email. I have it currently reading the save path and subject from the Excel worksheet.
[Code] .....
I have a folder in my D drive where I used to keep my Text files after downloading it from our support centeral. I want to Import all these Text files in one excel sheet in a way that data of each file got append in excel sheet below previous file data.I am trying to do this through FSO but unable to do the same.
View 1 Replies View RelatedI am using excel 2007. I have multiple folder with multiple files inside like below
folder1
file1
file2
file2
folder2
file1
file2
file3
folder3
file1
file2
file3
i need output like
folder1 file1 file2 file3
folder2 file1 file2 file3
folder3 file1 file2 file3
I need to use a function like =filelist(a1) or =filelist("folder1") then it should list the files horizontally like above.
How do I write a vba code to print active sheet to pdf, auto save in specific folder then mail using outlook
im using 'Nitro PDF Creator'
also id like it to automatically save the pdf as the same file name as the active worksheet and also auto enter the following when opening the email server:-
Address: Cell D18
Subject: Cell D21
Email body:
find attached quotation
Optional installation available on request
i am working with a large data set of excel files . I need to format the sheets in a specified way . i have recorded a marco that does this . I now have the problem of creating an automatic loader that opens the files , carrys out my macro , then closes the files.
For example i have a folder X that has 10 files inside it. i would like to be able to load the first file , carry out the macro, close the file move it folder y . Then look back into Folder X , take the first file it see's , carry out the macro , close the file , move it folder y , the go back to folder x and carrying out this until all the files are done and stopping when the folder is empty
I have a form in excel (very simple) that I need to put on the web - People can then fill out certiain bits of the information and the idea is that they then click on the button to email it back to me. Ie complete it there and then and email it straight away so that they don't need to save it etc.
I can't for the life of me work out how to do this! I've managed to get the macro to open an email with the correct details on but not paste in the information so am at a complete loss and appear to be going round in circles!
I have obtained a piece of code from online that runs a macro on multiple files in a single given a single folder. when i implement it though it throws a run time error 424 "object required' and point to 'Documents.Open FileName:=path & file' line of code. Is this because Dim file type is not declared?how do i fix this problem. also, im using excel 2010.A
VB:
Sub Mac()
Dim file
Dim path As String
[Code]....
I'm working on a project where I need to import 150 csv files into an Excel2010 workbook, with each csv file being on a seperate worksheet.
I would like to set up a macro to point to the folder I will have these saved in this up so that each month when I get updated csv files I can repeat the process and bring in the new data. how to create this, I'm very new to VBA?
For the last year I have been downloading cash register X1 and Z1 files onto an SD card. Each night's files (X1 & Z1) are stored in a new folder with the naming convention "RP + [DATE]", (EX: RP120910, [YYMMDD]). I have 265 folders! I need to go through each folder, select the Z1 file (I don't care about the X1, X2 or Z2 files) and rename each with the following naming convention: "Z1 + folder_name + .xls". For Example: Folder RP120910 contains the Z1 file named "Z1_T1729.ECR". After renaming, the file should be "Z1RP120910.xls". As the VBA code loops through each subfolder, selecting and renaming the Z1 files, I would like the new files to be placed into a new folder named "Z1Files". Note: All subfolders are currently in a directory named "RegisterFiles". I am using Excel 2010.
View 3 Replies View RelatedI am currently using Excel 2003. I have a worksheet with two tabs.
First tab has a list of bank Names. Second list has Bank Names and balances.
I need to find out the the average from a Bank in the first tab, to the same bank on the second tab that reflects the balances.
I need to find if there are matching addresses in 2 different excel files. If the same address appears in both files, I would like the new worksheet to return the address along with the sale price from the 1 file and the rental amount from the other file.
I have tried using vlookup but the problem is the exported data file contains the street number in one column and the street name on another column. I have attached a truncated example of both the rental data and the residential sales data.
I have alot of project folders on my harddrive.
All in format: I:/12345-costumer-projectname/
The five digits are unique for each project.
I make calculations for these projects using an excel file. In this excel I also type the projectnumber (cell J2)
Now i would like to make a button. When pressed, it checks the projectnumber cell J2, looksup the corresponding folder and saves the excelfile in PDF format in this folder.
I have found macro to find files in folders, but none which do the above.
I need a macro in a workbook to look at all the files in the same folder that have "*att*.xls" in the name and determine and copy from the range A15:W515 only the rows that have data in at least columns A, C and D. Each file will vary as to how many rows there will be and there are more than the files with "*att*.xls" in the folder. The data will be on the only worksheet in each file and the worksheet is named "G2WAttendee_xls" the data from all the files need to be copied to the file called "Consolidated webinar reports.xls" (I am using Excel 2003) and to a sheet called "Attendance Data" and added to the end of the last paste.
At the start of the macro the current file "Consolidated webinar report.xls" should be saved to a sub folder of the current directory and have the date saved added to the name. The sub folder is called "Completed reports". The data in the original file on worksheet "Attendance Data" should be deleted.
At the end of the process all the files that have had data copied from them should be moved to the sub folder "Attendance reports consolidated" (This could be done as each file is closed if that is easier).
I have headings in row 1 of the "Attendance Data" worksheet that match the headings in the various files in the folder (which will always be in row 14 of the individual "*att*.xls" files).
The folder with all the files and the "Consolidated webinar report.xls" file is at path "Z:P and S MEvaluationsWebinar series 2012-13TB".
Code below is trying to search for a deal number within all file names within a set folder. There is one file in the folder with th deal number within, but it isn't finding it.
Code:
Sub Macro1()
Dim lCount As Long
Dim wbResults As Workbook
[Code]....
I would like to search an outlook folder for a variable in the subject line and return the date when that email was received. Here is the code i have so far...
Code:
Sub Get_pos()
Set olApp = CreateObject("Outlook.Application")
Dim olNs As Outlook.Namespace
Dim Fldr As Outlook.MAPIFolder
Dim olMail As Variant
Set olApp = New Outlook.Application
[Code] ........
Is it possible to have a marco that will look at the data in a cell/multiple cells and search a network drive for a folder named with the same data in a cell? For example, I used a marco to create a folder from the contents in cell A2. Can a macro be reversed in that if I have a spreadsheet with a list of data in A2,A3, A4 and so on, can it check a network drive to see if a folder has been created with the same data?
View 10 Replies View RelatedUsing EXcel 2013, Windows 8
I have an Excel worksheet with one column being e-mail addresses. Other columns are Christian names, etc
Ideally can I create a full Mail merge with Outlook using whatever data I want. But probably just e-mail address and Christian name?
Otherwise be able to send one e-mail to all the e-mail addresses, without a major re-type.
I have an Excel 2003 file that contains hyperlinks to OneNote notebooks on a Sharepoint site. An Excel macro looks for these links and determines the full hyperlink address which is then assigned to a variable. An Outlook message is generated which includes the hyperlinks.
The hyperlinks work in the Excel file. I can also copy them from OneNote and manually paste them into an Outlook message and they work. However, when I obtain their full address and transfer that to the email through code, the links do not work. The hyperlink address from OneNote starts with "onenote:http" which is not recognized as a link.
If I can do this manually, there must be a way to do this with vba. Are there characters I need to include in the OneNote hyperlink address to make this work? Is there another way to transfer the working link from Excel to Outlook?
link a date within a Excel sheet to the Calander in Outlook so a reminder can be triggered on said date.
View 2 Replies View RelatedI'm in search of a VBA macro which will send a mail through outlook automatically with the count of files(.pdf + .msg files) in any given folder.
I work for an organization, where we use Outlook for mailing purpose.
Everyday Inventory(.pdf files and .msg files) will be saved in a folder that is to be processed.
I want a macro which should automatically send the total inventory (.pdf files + .msg files) through my outlook mailbox(say: me@outlook.com) to a my superiors outlook mailbox(say: superior@outlook.com).
If the macro sends that email to my superior before me and my superior logon to computers at perticular time (say: 7:00AM daily), need to plan our day at work.
I have to send out emails to all of my staff with their new login ID's and PW's and other misc information one by one to each user. Reason being is that all ID's, PW's and other information pertains to that specific user and includes sensitive information.
I know there's a VBA script I can use to send out the emails, but the script I found online keeps crashing my Outlook and requires it to go through my personal inbox which takes 15 minutes every time.
I have the pertinent information split up into different columns/cells.
A1: email
A2: subject
A3: body (ID, PW, verbage)
A4: attachment link (if required)
A5: if I could have Outlook automatically stamp each email with my signature that'd be awesome as well.
How to add an appointment to a shared outlook calendar from Excel. I will be entering shipments in an Excel page and would love to just click a button and have an appointment made. I am very much a novice on how programs communicate with one another. The only information that will need to go on the appointment is the subject, location, and time. We set all our appointments at 15 minutes duration. The code I have so far is this:
[Code] ....
The problem is it only adds it to my default calendar. I need to be able to add it directly to the shared calendar in Outlook.