Search results for query: *

Totally unfamiliar with Outlook Objects/Classes/members. So I’m right about here: SUB() End SUB Actually I'm pretty sure it's the recipient object I'm looking to access but I'm not sure how to get there.

Is it possible to setup a script to retrieve all email addresses in the “TO:” line of a received email and list them in a file (or spreadsheet)?

THAT's IT! trying to do it at the Module level. thanks again!

??? still missing something here. if I have a sub... Sub workbook_open() calllog.Shapes(1).Left = 51.5 End Sub on opening the workbook nothing happens (shape 1 doesn't move left to 51.5). what am i missing? yes i have macro enabled in a .xlsm workbook

man i am so bad at trying to explain things... try this again. if i want to perform a task, say clear the range $A$2:$B$10, when i open a workbook AND i want it to happen automatically (on open or close or anytime there is a cell change) what is the sub routine(s) to make that happen?

Another rookie question. Using Excel 2007 - pretty sure I remember these (and other) Events where available through the (and i'm sure i'm screwing the name up here) Excel 2003 VBA UI (drop down box above code window) but now I'm not seeing a way to access them. Is this a VB.NET change and if so...

Thanks to everyone! Between the posts here and the rest of the forum I figured it out. Here are the SUBs. Obviously a bunch more to the module a s well. If anyone has suggestions for the rookie coder on tightening up the code please le me know. __________________________________ Sub PullEmail()...

yes, actually can't even access VBA in 2007 without enabling macros. don't have a 2003 machine to ck it against. forces excel to shut down and restart??

trying to do a couple different things here. first i'd like to delete any hyperlinks i don't need. i'm using the following to do that but when run it bombs Excel. any ideas? try to resolve one at a time. For Each hl In ActiveSheet.Hyperlinks With hl If .Type = 0 Then...

Skip the Sub gives me a '1004' error and hangs on If Not .Shape Is Nothing Then

working in Excel 2007 and looking for a script to cycle through all of the Shapes on an ActiveSheet to see if any of them have a Hyperlink attached.

i'm cutting and pasting a webpage that includes a "mailto:" hyperlink in the form of a shape (see attached sheet). I need to anchor the shape (and thus the hyperlink) to the cell underneath the shape and then extract the hyperlink name. Seems simple enough but I can't find the method to do so...