Can you give me a little more information. You say you have a list on another sheet, is that a control? or is it just a list in cells? Also, what dat are you overwriting? Overwriting the cells? Do you want to select a value n the combo box and then do a vlookup to get a corresponding data...
PE,
How is it going? Did you get this to work for your application? I forgot to tell you the code(e15=45 is for the hyphen search. ANSI code for hyphen is 45. Let me know if I can be of further assistance.
Mark
Hey Steve,
Glad it worked. Yes Outlook has very little referenced support. I have a couple of references that I look at once in a while one is Micorsoft Press' Programming Outlook and Exchange by Rizzo. Also VB 6 Programmers reference source by Rahmel Osborne Press has some stuff in it. But...
Frank
Copy and paste the table from word to excel. Select the entire worksheet and go to format, cell, wrap text. Then paste. Are you pasting the table to cell A1, start of worksheet? If so first thing you need to do is go to the last cell of data below the row of your data. for example if...
Will this work
.SentOnBehalfOfName = "mhappe@ipsconsult.com"
the from field will contain this text.
the omailitem.send() just loads the mailitem into the outbox
try this as a test
Private Sub Command1_Click()
Dim myOLApp As New Outlook.Application
Dim myOLItem As...
Will this work
.SentOnBehalfOfName = "mhappe@ipsconsult.com"
the from field will contain this text.
the omailitem.send() just loads the mailitem into the outbox
try this as a test
Mark
How much memory in your PC? How much free hard drive space do you have? When was the last time you defrag'sd your drive? What application uses the ssgw6.drv driver file? Try going to msconfig/startup and prevent loading od the driver and then see if you ageve the problem. HAve you checkesd the...
Frank
What version of Word and Excel are you running? Have you tried a staight highlight, copy and paste into Excel? If so, what did not happen correctly? What type of formats are you wanting to preserve? What type of fonts are you using?
justimagine2525
Hello - Check this out. You did not say if the letter in parens was always at the end. This solution won't care. Also, you did not say if the hyphen column ONLY contains a hyphen, this solution assumes it does. Feel free to contact me at mhappe@ipsconsult.com
Find Parens...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.