Recent content by phoenix26

In VBA, I am trying to to return the exact location (column and row) of a cell in an Excel worksheet? Would someone please help me.

I have multiple Outlook accounts on my computer. In VBA, if I want to automate a message to be sent via Excel, what is the VBA code to specify the FROM field in the Outlook email message? I tried objMail.From but it errored out. Please help. Thank you!!

Nevermind. I found it!!

Cool. I added the code to a sub/end sub section and now can call it sucessfully through a command button click procedure. Can you provide me a sample code for sending the Excel field information to an Outlook email message?

Thank you firefytr. To answer your questions: What exactly are you wanting to send from Excel? > I want to send a dynamic letter composed of fields in Excel. For example, one of the column will be email address, another column will be a BODY, where the BODY will be a series of concatenation...

I have a followup question regarding an archived thread. thread707-1124624 When I try the code in the thread, I encounter the following error while compiling in VBA. "Invalid outside procedure" I am using Excel 2003 and when the error occurs, it sets the cursor at the SET OLAPP line. Would...

What I need to do is send about 10-15 emails a day to a list of customers and because of company policy, I am restricted to only using Outlook 2003. They refuse to give me any access to a webserver, because everything at work has to go through their proxy and so that is why I can only use...

Microsoft Windows XP Home Edition? My new laptop came with Home Edition and I would like to login as Administrator. Someone please help me.

I am still unable to get my laptop to restart. Does anybody have anything else I may try?

I have reformatted the hdd with NTFS file system and then I tried both using the original System Restore cds and then the original Windows 2000 installation cd. Both methods resulted in the same outcome. The laptop would boot up fine and shut down fine. When I attempt to restart, all open...

I have a laptop that is experiencing a very strange symptom. It can boot up fine and shut down fine...but whenever I try to RESTART, the thing closes all the program and 'hangs' at a black screen. I have updated the BIOS, reimaged with the factory system restore cd's and then even tried...