I want to take a copy of an excel document and send it to another user who want to see the values of the results and not have to have all the links and formulas. If there a way to save or publish a document so you change all the current values into values on the screen and remove all the formulas and links to other documents or workbooks that are based in my folders. I just want the values in another spreadsheet and it will show my tables and graphs in the same manner.
I want to have the same format as the first one i.e., without the path. When the potx files are refreshed the link file will always be opened, so i do not need the path (this is part of a vba program).
The folder containing the files will be sent around and put in different drives.
'EHS Reports' is the main folder and that and everything else inside will remain the same. But the ppt links will not change so obviously will not update when the 'EHS Reports' folder is somewhere else.
I have written code in VBA to send emails via Excel based on a name that is held in a spreasheet that is then looked up against an organisation address book. What I need to know is there anyway that you can save mails into the Draft folder that were unable to send for example if they have an email adress that is incomplete or not recognised or if the email box has reached capacity?
i have the following code in my Excel worksheet. This code successfully send out email to our customers when if the criteria is true. I have tested this at home and it works perfectly as I use Outlook at home. However when I take this code to work I couldn't get this working as at work we use Outlook 365 and we use web Outlook, OWA.
Is there a setting I can specify to use OWA as I don't think I am allowed to install outlook at work.
I have a database file that I use for tracking "Requested Laptops" ( so that technicians can request the model they need ) and what model they want. There are three of us that distribute laptops ( asset managers ), and we have a box that we use to say we distributed it. For example:
TECH REQUESTING .. . . . DATE . . . . MODEL NEEDED. . . . . FOR WHO . . . . . . . STATUS OF REQUEST . . . . . SERIAL NUMBER PROVIDED. . . . . . ASSET TAG PROVIDED.
Those are the columns. The "Status of Request" Column uses data validation "list" and can either say:
When the technician first requests, he selects "NOBODY/PENDING" and there is Conditional formatting that highlights the row RED so that we can easily see that there is a pending request. Once laptop is distributed, we change this field to Wes distributed for example, and the row is highlighted green.
Now that you have the basics of the file, what I'm looking to do is find out if an email can be sent either by Outlook or SMTP, so that when a technician enters the request and changes that field to NOBODY PENDING, an email is sent to all 3 asset managers saying "Please be advised that an asset has been requested by [TECH REQUESTING]. expedite."
I have an excel sheet on which to address, cc address, subject , attachement location and file name is mapped. Can some one help me out but executing the macro it will pick the file from the location and send to the Recipient with cc and subject and attach the file accordingly. The excel sheet is attached for your reference.
I have a problem concerning sending an active word document via mail. I have a worksheet with various information in it, that I am exporting to a word document. I then want to send the word document via email. I want to do this without saving the changes in the word document. I am working with excel 2010. I have posted some of my code below.
VB: Sub letter() Dim myWord As New Word.Application Dim adr As Variant
I get the following errormessage: "Compile error. Wrong number of arguments or invalid property assignment"
I find out a code to create a PDF (with opening the Save As dialog box) from an active worksheet, but I can't find out how to send this PDF by e-mail (Outlook). The code is working till the words 'Set OutApp'.
Just what I want is to send the active worksheet as PDF (as attachment) by email (Outlook). Here the present code.
Code: Sub SendPDF() ' ' SendPDF Macro ' Dim OutApp As Object Dim OutMail As Object Dim v As Variant v = Application.GetSaveAsFilename(Range("E2").Value, "PDF Files (*.pdf), *.pdf")
I want to send emails to about 12 - 14 people with various different excel spreadsheets using macros. This is after I have finished running a macro that splits a report into various departments and needs to be emailed to the heads of each department. I want to be able to attach each ecel report to its owner and have the macro email it for me once the reports have been generated.
Would like to find a formula or macro which would automatically send an email to let me know when a date entered into the specific cell is coming close to expiration. e.g. if the date 01/05/2014 is entered into a cell i would like an email to be sent to me a month before the date is reached (01/04/2014).
I am mostly using excel for simply data gathering and tracking. Require exact steps to be followed to accomplish the following:
- Sending automated reminder mails if current date is 15 days prior to "TO" Date - Sending automated reminder mails if current date is 10 days prior to "TO" Date - Sending automated reminder mails if current date is 05 days prior to "TO" Date - Sending automated reminder mails if current date is same as "TO" Date
Also, would be great if automated mails can be released if current date is 1 day past "TO" Date and showing "Overdue" in "Status" Column.
Below is sample data which gives an idea of the data kept and the requirement.
Exception ID Requester Email ID System Name
OS Detail- Windows 7 Microsoft Office - 2010 Microsoft Outlook- 2010
I have created a spreadsheet that displays new dates in column D based on provided dates in Column B and recurrence intervals selected in column C. The dates in column D are when a training deadline occurs. I have been trying to get a macros written so that when a cell in column d is updated, an outlook appointment message is sent to the person doing the updating. The idea here is that anyone can use this without future coding (so their address would be placed in cell say A1)
So far all i have gotten is excel to send an email to me with the excel spreadsheet as an attachment, not really what I want. Again, I dont want somethign specific to my computer settings, I want to be able to send the spreadsheet out with simple instructions for the user to change their email in cell A1 and then every time a cell changes in column D, it automatically generate an appointment reminder for the new date.
I have inherited an excel document that has dashboards, data pages and pivot tables. There is macro and links within this but I can not view the macros at all. When trying to update the links ( using break,update, change) it appears to work ( changes to OK) but the location field on bottom of edit links page NEVER goes to new location and the MANUAL button is greyed out. I need to be able to update this master file tomorrow with the multiple excel sheets I will get but do not know how to do it if can not update links proeprly or even be able to view the macro
I want to use the move/copy worksheet function to copy a worksheet from one workbook to another. When I do this I want it to Not refer to the workbook it was copied from in the formulas and lookups. I have tried copy/paste special also and it doesn't work.
I copied 2 worksheets from one file to another and went in to "Edit Links" and changed the source to itself rather than the original file which took away those links in the cells that the original file was present in, but it still gives me a dialogue when opening the file that links to the original file. I go back to "Edit Links" and press "Break Link" but it doesn't seem to remove the link to the original file. If I click on "Connections", none are present. I clicked on "Startup Prompt" and set it so that it wouldn't annoy me with the prompt any more, but I'd ideally like to not have any reference to the original file.
I have a couple of functions in a excel addin file which is located on a network, i have been having this issue on a few spread sheets now and decided to test it on a completely new blank sheet.
The function i am using to test is called "extent" and it is called fine when loaded on one machine, loads fine on another machine, saved it. Load it up on another and the link is completely wrong. It is completely random between machines.
The link it loaded is an old one i have used before that is not in use, but it was not associated with this spreadsheet file in anyway. Is there anyway to force excel not to update these links automatically as the manual option is greyed out.
I can not fathom out why excel puts in this network location.
I have attached some screenshots, the correct network location is PODDrop BoxesPOD_AdminAddins
I copied (with 'Paste Link') rows from a master Excel file to a file that performs calculations. This file (and many others like it) need to be modifed by other people. My tester has informed me that the data is not updating between the files for her, although it does work for me.
When I check 'Data->Edit Links' it shows the status of the file as 'unknown'. If I click 'Check status' it is then OK, but the next time I look at it, it has reverted to 'unknown'.
1. How do I get the status to remain at OK?
2. Why do the links work for me, but not for my end users?
I have excel graphs linked to a power point presentation that runs in a loop and I would like have to the links update everytime slide 1 pops up or when the loop restarts, either one works for me. When I close the looping presentation and reopen it I get a message asking me if I want to update the charts, but I would really prefer the looping presentation to update itself. I know this is going to be a VBA setup, but I cant seem to figure it out. I pasted the links by: pasting special, paste link as microsoft office excel worksheet object.