Automatically send attachment in email with a submit command button in word

Visual Basic for Applications (VBA)

‹ Microsoft ISV
- Archive
  - VB
  - Smart Device
  - Visual C#
  - Visual Studio
  - Dotnet
  - VS Express
  - VFP
  - Architecture
  - Windows Forms
  - Windows Vista
  - SQL Server
  - Windows Live
  - Office
  - VS 2008
  - VC++
  - Game
  - ISV
  - SharePoint
  - IE

- Previous
  - 1
    - help required related LCS(Live Communication Server). i wanted to make a client that will get the status/username of the user from the LCS and initiate a collaboration chat session between the LCS users and between my client application.........is it possible our nt . Tag: Automatically send attachment in email with a submit command button in word
  - 2
    - this problem is also troubling me now!! :( Hi I have also tried setting site.AllowUnsafeUpdates = true It does not help too. Please direct me where i am missing. tia sahridhayan Tag: Automatically send attachment in email with a submit command button in word
  - 3
    - Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset There are two solutions to this problem. 1. Adjust the DPI back to the standard settings. --> Right-click your desktop and go to Properties --> Click on the settings tab --> Click on advanced --> Change the DPI setting back to "Normal" 2. Edit the registry. --> Go to Start, Run --> Type regedit and click OK --> search for "UseHR" --> Adjust the value from 1 to 0 Depending upon whether or not you want to use the High Res DPI scaling or not do one of the two options. This link descibes it in a little more detail. Tag: Automatically send attachment in email with a submit command button in word
  - 4
    - WMI.Net 2.0 If you install the Beta 1 of Orcas, you will find the documentation describing attributes (already available). With the Beta 2 of Orcas, you will find code sample added to the documentation (summer) HTH /Alain Tag: Automatically send attachment in email with a submit command button in word
  - 5
    - Word document Hi Friends I have two word documents.I have to compare the both documents.The difference between the two document is that the second documents contains an image,insert some data or delete some existing data.I am able to find the changes and store the result in another document in which the changes reflects.Now our main moto is how can the end user identify that there is a change of only image in both the documents without opening the word file. Thank & Regards Tag: Automatically send attachment in email with a submit command button in word
  - 6
    - iexplore.exe - Application Error Hi Bennett, How did you remove the yahoo tool bar I have the same error message. Thanks, Eric Tag: Automatically send attachment in email with a submit command button in word
  - 7
    - How do I deal with files of more than 65k rows? Hi Do you really need to be working with all 2-3 million rows, or is it just 5 to 10 seconds of data you want to work with at once Once you've processed the data can you "discard" it If you really need all the data then consider storing it in an Access or other database. You can still process it using Excel/VBA. If you can get away with just 5 to 10 seconds then read that much in, process it and throw it way before you read in the next 5 to 10 seconds worth. Regards Peter Mo. Tag: Automatically send attachment in email with a submit command button in word
  - 8
    - Using VBA macro to locate next free column on worksheet Hummm... so true so true. Mine only find the last column in the whole sheet, not your custom defined range. Better suscribe to this thread before I upgrade my functions to this. This can be used for so many different situations, like a single row, a set of rows, and the whole sheet. Thank you so much for your code. Tag: Automatically send attachment in email with a submit command button in word
  - 9
    - Setting a Bookmark to insert a Page Break in MS Word Hi! I know how to use setBookmarkString, but I need to insert a Page Break with a Bookmark. What Function do I use thanks in advance Pieka Tag: Automatically send attachment in email with a submit command button in word
  - 10
    - Macro - Replacing Contents of Cells When dealing with the a spreadsheet, is there a macro code that would replace the contents of a cell with a "0" for all of the cells in each column in the Questions worksheet that do not match the criteria from a specific cell in the Solutions worksheet I received wonderful help for a similar question on the same worksheet with the following original question: I am trying to write a macro that will use one sheet, Solutions (Sheet 1), with a specific cell range, B2, and find and replace the reference from cell B2 in a specific column, G, in Sheet 2, Questions, and replace with the value 1. Right now I am using B2 from Solutions Sheet 1 that contains the cell named Financial (Revenue) reporting, and using that as a specific search criteria in column G, but is there a way to use the reference B2 and find and replace cells in column G that are also labeled Financial (Revenue) reporting without using the actual name "Financial (Revenue) reporting" but if the cell in column G, Sheet 2 Questions, matches B2, Sheet 1 Solutions, then replace that specific value in column G, Sheet 2 Questions, with a value of "1" The following is the outcome from that original question that I am building my spreadsheet from: Code Snippet Sub Macro1() ' ' Macro1 Macro ' Macro recorded 5/8/2007 by Rachel ' ' Sheets("Questions").Range("G:G").Replace What:=Sheets("Solutions").Range("B2"), Replacement:="1", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:= _ False, ReplaceFormat:=False End Sub Thank you! Tag: Automatically send attachment in email with a submit command button in word
  - 11
    - Getting data from other workbooks I have a master Excel file named (master.xls) and other slave files called ( slave1.xls, slave2.xls, slave3.xls ....salve5.xls and so on. ) master's structure is exactly the same as other of other salves where they all contain a number in cell A1 master will first select the slaves. And master wants to calculate the sum of A1(s) in slaves and have the result put in B1 of master.xls getting A1(s) from slaves may open and close slaves, however I want to have the open and close done in background. How can I do it Tag: Automatically send attachment in email with a submit command button in word
  - 12
    - Run Time Error 9 when Calling a Userform The problem is this line in the Initialize event Workbooks("TradeDB").Activate The reason is works some of the time is that some of the PC have the option to hide known file extension types. So the file TradeDB.xls will sometimes open with that name and sometimes with just TradeDB. Including the .xls should work in either case. Workbooks("TradeDB.xls").Activate Tag: Automatically send attachment in email with a submit command button in word
  - 13
    - Excel CheckBox - Enabled "False" but I don't want it grayed out I take it that it is not possible to acheive this Tag: Automatically send attachment in email with a submit command button in word
  - 14
    - iexplore.exe - Application Error Hi Bennett, How did you remove the yahoo tool bar I have the same error message. Thanks, Eric Tag: Automatically send attachment in email with a submit command button in word
  - 15
    - Parse AIM Buddy List Export file and Import to LCS 2005 Client I'm working on a migration project from the wide use of AOL AIM to Office Communicator 2005 and Live Communication Server 2005. I can create a text file export like the following: Config { version 1 } User { screenName thereScreenName } Buddy { list { "GroupA" { "buddy1" "buddy2" } "GroupB" { "buddy3" "buddy4" } } } There could be any number of groups. I will provide variable inputs for the input file and output file locations. I need to be able to make a new file like: buddy1 sip:buddy1@aol.com buddy2 sip:buddy2@aol.com buddy3 sip:buddy3@aol.com buddy4 sip:buddy4@aol.com I am completely a newbie in C#, but I was requested to use it. Any assistance would be great. I will request that the resulting tool be open source and publicly available, so please keep that in mind. Tag: Automatically send attachment in email with a submit command button in word
  - 16
    - How to make a macro to copy some parts of a table to an email that it will create? Hello, I myself rarely coded in Word, so I can't help you much. But I think what you need can be achived if you know how Word object works. Like how to retrieve table object. How to access cells through table object. And such. The crappy part about Word is that it is hard to record meaningful macros; it mostly record key strokes rather than the macro code to access objects. So, you have to look into the documentation yourself. Excel is a much better platofrm IMO. I will just tell the user to use Excel instead, hehe. Tag: Automatically send attachment in email with a submit command button in word
- Next
  - 1
    - Excel VBA Hi everbody! I am using Excel and I wrote a code using VBA. I have subroutine which open and read text file. I call this subroutine in the master program. The object of the program is to open read a text file(numeric) and make average of the data , make a table and fill the table with the data. However, I want to modify the program so that it can open 5 text file at the same time and process the data. Below I have a code that open and read one file. Could you please give me an advice how to open and read multiply files at the same time Thanks in advance Filename = Application.GetOpenFilename() Close FileNumber = 1 Open Filename For Input As #FileNumber ' Get data, here I call the subrutine that read the data Close If DataCount = 0 Then MsgBox "No data" Exit Sub End If Tag: Automatically send attachment in email with a submit command button in word
  - 2
    - .mdmp files not being created Hi Claus, Yes, well, it would be much nicer to have the dialog when ForceQueue=1, because otherwise the user won't even know a crash has occurred until the program is noticed missing! If the program has no UI, that is hard indeed. I appreciate your words on the workarounds, but only the Corporate server seems like the real deal. (I can't imagine asking the user to unplug the Internet!). That tidbit really came in handy on explaining what to do to get minidumps to work on Vista. Best, David Tag: Automatically send attachment in email with a submit command button in word
  - 3
    - How do I accomplish this in VBA using Office 97 and later? I am trying to come up with a system that would improve efficiency in creating Request for Quote and Purchase Orders. As an example, here is what I am trying to do with the Request for Quote. 1.) A new document from a template called "Request for Quote" is created. 2.) The system asks for an Excel file to import that has bid item information in specific columns and from a set row down to the end. 3.) The system uses an Outlook address book to pull up a list of vendors. You can then select a checkbox control next to each vendor to include the vendor. Vendors are displayed one by one from top to bottom. 4.) The same thing done in step 3 is performed for the bid items using the Excel file imported earlier. 5.) The information is appropriately placed in the template. I can apply the Request for Quote concepts to Purchase Orders. Any idea on the most efficient way to accomplish this type of system Tag: Automatically send attachment in email with a submit command button in word
  - 4
    - ASP .NET 1.1 fails at install, but not .NET Framework 1.1 Hi there, My Scorecard Manager 2005 installation finds that I do not have ASP .NET 1.1 installed, but it finds .NET Framework 1.1 installed. I could not find a download for ASP .NET 1.1 outside of the .NET Framework 1.1. Can anyone explain in a few words what is the difference between the framework and the asp .net To note that when I try to install the .NET Framework 1.1, which I cannot see installed in my programs, the installation is failing due to product already installed. I am a little confused. The OS is Server 2003 SP1. Thank much. Tag: Automatically send attachment in email with a submit command button in word
  - 5
    - How to allow cookies for Windows Live ID I am having the exact same problem..and error message. Anyone know how to fix this Diana Tag: Automatically send attachment in email with a submit command button in word
  - 6
    - Projects, objects & modules Does the line of code appear on 1 line or 2 This will error MsgBox " Thisdocument is " & ThisDocument.Name This should work MsgBox " Thisdocument is " & ThisDocument.Name Tag: Automatically send attachment in email with a submit command button in word
  - 7
    - A macro to count the number of macros in a woorkbook Hello all, I need to loop through a bunch of excel workbooks, open them, and determine if there are any macros in the workbooks, and if there are, how many. I know how to loop through the workbooks and open them. But how can I display the names of the macros that are defined in the workbook This must be possible. Thanks! Tag: Automatically send attachment in email with a submit command button in word
  - 8
    - ComboBox listing on Startup When I type in manually 'Open App1' the other sub executes the additem but still no listing in the combobox. Private Sub Auto_Open() ComboBox1.AddItem ("Open App1") ComboBox1.AddItem ("Open App2") ComboBox1.AddItem ("Open App3") ComboBox1.AddItem ("Open App4") End Sub Tag: Automatically send attachment in email with a submit command button in word
  - 9
    - PASSING MS OUTLOOK DATA TO EXCEL Is it possible to pass Outlook information such as dates and durations of meeting to an Excel spreadsheet I would need to do this via a macro. I need this to create a time card that tracks how much time is being spent in meetings. Thanks! Tag: Automatically send attachment in email with a submit command button in word
  - 10
    - MDI on old Office but not on new Office 2007? I had regularly emailed myself in the past from my older version office {2003} {work laptop with no printer attached} to my newer office XP on my personal system to print but now that I have upgraded to Office 2007 the MDI is not recognized. How can I install the MDI drivers so I can print again Tag: Automatically send attachment in email with a submit command button in word
  - 11
    - referenced memory error hello people. can someone help me. My computer displays an error saying instruction at "0x269e7875" refernced memory at "0x269e7875". The memory could not be "read". Click ok to terminate the program. And I cannot switch from one user to another. I can log-off from windows and switch user. It needs to be restarted every time I want to switch from one user to another. Tag: Automatically send attachment in email with a submit command button in word
  - 12
    - Visual Basic Code Corrupted? Hi, I have been having several problems on a complicated excel spreadheet that I have been developing, that have led me to believe that the file i am working on has been corrupted. The problems started when I switched PC's that I used for developing (i.e. was given a slower PC to work on). Since then, I have been having all sorts of problems with my macros. Now, even when I open the file on other, faster machines, the results are still unstable, with features that were previously working normally still not working. Is it possible that the PC that I switched to has somehow corrupted the compiled VBA code stored in the excel file For example, a simple procedure that hides some columns on a sheet when a value is changed is not working. However, when I duplicate the exact same code, and trigger it when a different value on the sheet changes, the new procedure works. (The old procedure has a problem with activating the sheet on which to hide the columns). As the code is exactly the ame, could it be that the already complied VBA code in the excel file is corrupt Many thanks for any help! Tag: Automatically send attachment in email with a submit command button in word
  - 13
    - Removing "Trial Version" from Web Components on SharePoint web sites Hello, I would like to remove the "Trial Version" as stated above. I used CSS but then other part disappear as well so this is not an option. Then I tried JavaScript but wasn't working either. Question: is it somehow possible to do it with JavaScript (I have only limited scripting capabilities). Or can I directly access the template that creates the different sharepoint web sites for my purposes I would appreciate advice on this matter and thank you for your attention. Regards Christian Tag: Automatically send attachment in email with a submit command button in word
  - 14
    - Multithreading with VBA6 and Access Hello, I'm not so familiar with VBA/Access. I have to maintain an existing application. Now I need that a user can use the application and in the background a function must at certain times (these times are in a table param) lookup and export a XML file from a query. IS IT POSSIBLE TO CREATE MULTITHREADING WITH VBA AND ACCESS AND IF YES HOW I read at some forums it should be possible but I have never read how Thanks in advance. Nico Tag: Automatically send attachment in email with a submit command button in word
  - 15
    - Validation with List drop down? Hi Tried using above on one of my projects and the Worksheet_SelectionChange code needs amending to : Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Dim rsp If Warned = True Then Warned = False Else If LastRange.Column = 4 Then If Range("C" & LastRange.Row).Value = "No" Then If Len(LastRange.Value) = 0 Then Warned = True Range("D" & LastRange.Row).Select rsp = MsgBox("Please enter reason", vbOKOnly) Else Set LastRange = Target Warned = False End If Else Set LastRange = Target Warned = False End If Else Set LastRange = Target Warned = False End If End If End Sub Tag: Automatically send attachment in email with a submit command button in word
  - 16
    - How can I show the formula result in my cells? I assigned a formula to Range(D2 10), but I cann't see the formula result in the spreadsheet, what I can do is only show the result by using msgbox. So how can I show my formula result in the spreadsheet Thanks so much! Private Sub CommandButton1_Click() Worksheets("MMS_RSP_Tonnes").Range("D2 10").FormulaR1C1 = "=MMS_RSP_GSV!R[0]C[0]*1000/GSVperTonne!R[0]C[0]" Dim A As Variant A = Worksheets("MMS_RSP_Tonnes").Range("D4").Value MsgBox A End Sub Tag: Automatically send attachment in email with a submit command button in word

Desperately need help

I have a huge problem if anyone out there is able to help; I have tried to create a submit command button to email off a document as soon as the user hits submit; however i am new to this and my macro does not seem to be working. Does anyone know where i have gone wrong and if possible can you please help rectify the problem. Thank you

Sub CommandButton1_Click()
Dim Email As Object
Dim Attachment As String
Set Email = CreateObject("Outlook.Application") 'Assign Outlook application to variable
With Email.CreateItem(olMailItem)
.to = "<>" 'email address
.Subject = "Incident Report" 'Something for the subject Field
.body = ActiveDocument
.Display = Attachment
Options.SendMailAttach = True

End With

Re: Automatically send attachment in email with a submit command button in word

duck thing

What errors are you seeing

Re: Automatically send attachment in email with a submit command button in word

Desperately need help

Its not coming up with any errors its just not working at all. im not even getting the email up.

Re: Automatically send attachment in email with a submit command button in word

ADG

Hi

Did you remeber to send the mail item in your code