Search results for query: *

8.5

All, I have tried HughLerwill's suggestion of: Call MailDoc.REPLACEITEMVALUE("SendTo", Array("1stRecip@some.com", "2ndRecip@somother.com")) And it worked perfectly! :) Thank you HughLerwill and to all who contributed!

Tried HughLerwill's suggestion, but am receiving an error: "Object doesn't support this property or method" Sub EmailCashDetailReportLotusNotes() Dim Maildb As Object Dim MailDoc As Object Dim Body As Object Dim Session As Object 'Start a session of Lotus Notes Set Session...

Just tried. Only the first recipient received the email. The second email address cut off "@domain.com". I tried both with and without a space between the semi-colon and second address. Same result.

I have a sub that generates a Lotus Notes email via VBA. Everything works great when sending to only one recipient. How can I send to multiple recipients? Sub EmailCashDetailReportLotusNotes() Dim Maildb As Object Dim MailDoc As Object Dim Body As Object Dim Session As Object...

Thank both of you so much for your input. Having not done anything like this in the past, I was lost on where to begin. Now that I have something to work from, I will be able to understand what is going on and how to apply in the future. I will work out the code from your examples and post any...

I don't even know where to begin. I am a novice. All I was able to do was to think of some of the variables needed. But as soon as I did that, I had no idea where to go with it. 'Name OldPathName As NewPathName Dim strMMDD As String, strMDYY As String, strMMDDYY As String strMMDD =...

Thanks for all the tips, everyone. Unfortunately, this area of VBA is very new to me. I believe using FileDateTime would be acceptable. However, I still am having trouble applying it or even just getting started on how to code this entire scenario. I know this may be a tall order, but I wonder...

Thanks, Skip. I have checked it out and it looks to be what I am looking for. I have started trying to think through how to incorporate my criteria and keep coming up short. Any thoughts on how to code for the given criteria?

Using Excel, I need to create a macro to be run daily (manually via command button) to move files all located in one source folder to various destination folders depending on the file name and whether or not the file's name contains a variation on today's date. Source Folder: "I:\RP\Source\"...

After a little more trouble-shooting, I have found that the issue seems to have to do with the document being a template (dotm). When testing the buttons from within the template, they work properly. However, when an iteration of that template is created (Document1.doc), the command button...

The original code I have posted, was found on the internet. I honestly don't know what the difference between an inline shape and a shape is and am unable to find it defined. Therefore, I don't know that what I have posted is even the correct start for what I need to do. Had I not posted the...

Nothing happened. Did not delete object.

Produces the same result as my original issue. Once this code is run, the intended object deletes, however all other command buttons on the document seem to change to a disabled state - click on them, nothing happens.

It did not make it invisible. Run-time error 438: Object doesn't support this property or method.

Sounds like an adequate solution. However, I am not realizing what the code should be in order to accomplish this. Tried updating to obj.Visible = False, but did not do the trick. :\

I have a Word document with multiple command buttons. One command button (cmdIntroduction) in particular initiates a user form. When the user selects Submit on the user form, the folling code runs: For Each obj In ActiveDocument.InlineShapes If obj.OLEFormat.Object.Name = "cmdIntroduction"...

Something like this? ThisWorkbook Public Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If bSave = False Then If Environ("username") = "n264rsp" Then bSave = True Else bSave = False End If If Not bSave Then Cancel = True MsgBox...

I have a template workbook that must be saved by initiating an on-sheet command button. I have code below that disallows the user to save via the normal channels, yet still allows me (my user id) to do so to make updates to the original document. However, I DO need the user to be able to save...

Works beautifully. Thanks PHV!