.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

Microsoft Word Mail Merge Problem

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :ASP.Net
 

I wrote code to create label from Microsoft Word Mail Merge using Visual Studio 2008 ASP.NET C#. This is my code:

public void CreateLabel(string strCSVPath, string strTemplatePath)
{
            Object fileName = strTemplatePath;

            Object missing = System.Reflection.Missing.Value;
            Object oEmpty = "";
            Object oFalse = false;
            Object oTrue = true;
            Object oAutoFormat = word.WdOpenFormat.wdOpenFormatAuto;

            word.Application wApp = new word.Application();
            word.Document wDoc = wApp.Documents.Open(ref fileName,
                ref missing, ref missing, ref missing, ref missing, ref missing,
                ref missing, ref missing, ref missing, ref missing, ref missing,
                ref missing, ref missing, ref missing, ref missing, ref missing);
            word.MailMerge wMM = wDoc.MailMerge;

            wMM.OpenDataSource(strCSVPath, ref oAutoFormat, ref oTrue, ref oFalse, ref oTrue,
                                ref oFalse, ref oEmpty, ref oEmpty, ref oFalse, ref oEmpty, ref oEmpty,
                                ref oEmpty, ref oEmpty, ref oEmpty, ref missing, ref missing);

            wMM.DataSource.QueryString = "SELECT * FROM " + strCSVPath;

            wMM.Destination = word.WdMailMergeDestination.wdSendToNewDocument;

          


View Complete Post


More Related Resource Links

Mail Merge

  

Hi,

 

I am after creating a mail merge documents from datasource and .dot template file on server side. Can you give me an idea how i will achive this?

 

Thanks in advance.

 

Regards,

Syed Hussain

 

 


Charset Problem with dynamically generated Word Document

  

in my asp.net web application i am dynamically generating a word documnet out of a sql data. I have set the char set UTF-8 during the doument creation in code but still when i open the generated document and check it char set .. it is always windows-1252 not the one that i have set. My sql data in the document have special characters whihc can only be understandable using the UTF-8 charset otherwise its always ?T written in place of an apostrophy . Pasting my code here..

         HttpContext.Current.Response.Clear();
         HttpContext.Current.Response.ContentType = "application/msword";
         HttpContext.Current.Response.ContentEncoding = System.Text.UnicodeEncoding.UTF8;
         HttpContext.Current.Response.Charset = "utf-8";
         string strFileName = "Details" + ".doc";
        HttpContext.Current.Response.AddHeader("Content-Disposition", "inline;filename=" + strFileName);
        StringBuilder strHTMLContent = new StringBuilder();
        string strMessage = " ";
        DataView abstractview = (DataView)dsAbstract.Select(DataSourceSelectArguments.Empty);
        foreach (DataRowView row1 in abstractview)
        {
            strMessage += "<table border='1' cellspacing='0' cellpadding='5' width

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

  
Hi,

I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies



Any help will be very appreciated!

Thanks,
-Raj

merge word document

  

Hi,

I recently created a team site on the SharePoint for projects management and our team will use the word document for inserting the information about the project that they work on it,

My case is:

for each project have multiple documents and i created a user control by VS.2005, this user control contain a drop down list contain all projects and merge button, when the user choose any project and click merge i will use the Work dll to merge all document that related to the project and export to the user.

This is my code

private void mergeDocument()

{

ApplicationClass WordApp =

System.Net.Mail HTML Template Problem

  

What do I need here ?????? To make this work??


Dim MassMail As New MailMessage()


        Dim Template As ??????????????


        MassMail.To.Add(New MailAddress(TextBox_massemailto.Text))
        MassMail.From = New MailAddress("You@me.com")

        ' MassMail.CC.Add()
        MassMail.Subject = TextBox_massemailsubject.Text
        MassMail.Body = TextBox_massemailBody.Text
        ' MassMail.Body = Template.BodyFileName = "EmailTemplates/BusinessAdBrochure.htm"
        MassMail.Priority = MailPriority.High

        Dim smtpclient As New SmtpClient("relay-hosting.secureserver.net")
        smtpclient.Credentials = New System.Net.NetworkCredential(""You@me.com"", "pasword")
        smtpclient.Port = 25
        smtpclient.EnableSsl = False
        smtpclien

Generating MS Word doc from mht file gives smart quote problem

  

I have a word document to be generated using ASP.Net/VB.net.

So I have a word document template saved as .mht file on the web server.

In my ASP.Net code,I read this mht file content and replace certain string line Description$$ with the actual description from the database.Then save this content as .doc file.

This works fine but shows a box symbol when I have smart quotes " (not this one as I cannot type it here.The double quote which you see in MS Word,the slanted double quote).

I dont know how to make my word doc generated, show the exact double quote as in MS word.

If any of you have any idea of this please reply.

Thank you


How to use Microsoft.office interop.word in website

  
Hi, I have a page which creates a word doc from templet string location = Server.MapPath("~/temp/" + filename); Application app = new Application(); Document doc = app.Documents.Add(location); if(doc != null) { //Some code here } it works fine when i run from visual studio, but when i deploy it as a website in local IIS, its not working.I gave the permissions needed to access the folders in the website. What should i do to make it work. Thanks

saving docx as pdf with Microsoft.Office.Interop.Word in sharepoint

  
Hi!Im trying to export my docx file to PDF with Microsoft.Office.Interop.Word but im stuck. Anyone with some great ideas that could save my day.The code that im running is working fine localy but i can´t get it to work in sharepoint.The most commin exception is file not found (the same path is working fine localy)...Pls give me a hint!

Microsoft .net framework 1.1 installation problem

  
Well I know there is numerous posts about .net framework 1.1 installation failure,I have searched through a lot of them.I failed to resolve my  problem so I am posting this.when I try to install .net framework 1.1 redistributable package which I downloaded from here it installs  .net framework version 1.0.3705 then when I want to install .net framework 1.1 service pack 1 downloaded from here which has the file NDP1.1sp1-KB867460-X86.exe  it doesnt install showing the message  ''The upgrade patch can't be installed by the windows installer service because the program to be upgraded may be missing,or the upgrade patch may update a different version of the program.Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.'' I have tried a lot of way to solve this including:using the stebner cleanup tool to erase all versions of framework then restarting  machine and reinstalling again but this way can't solve the problem,modifying registry etc.Other versions(1.0,2.0,3.0,3.5) are installing smoothly they are not creating problems only this fw 1.1.How can I resolve this issue.Please anyone help

Html editor word wrap problem

  
I created an html editor which uses an iframe for designing. The iframe doesnt wraps the text within it.... but the text keeps on extending in the same row towards the right. i tried setting scrolling='no' but it didnt work... tried word-wrap:break-word but thats also of no use........ please help! 

Microsoft Word hyperlinks not working consistently in Sharepoint

  
I'm running into an issue with some Word hyperlinks.  I have a Word document (with embedded hyperlinks) uploaded to a document library.  If I go into the library and click on the document, the hyperlinks work as intended (which is to say that the embedded hyperlinks open up a .pdf in a NEW window). However, on my home page, I have a link to the Word document directly (not to the library, to the actual file).  If I use this link, then the embedded hyperlinks open the .pdf in the SAME window. Part of the issue seems to be that when I open the document from within the library, it opens it with what I'll call a Word emulator whereas if I follow the link from the home page, it opens it with a regular web browser.  Is there a way to get the link from the home page to also use this emulator?  Alternatively, are there any other solutions?  I really need to be able to use the home page link method.

Problem to use unicode chars in yahoo mail

  
Hi i have a problem to send email via smtpClient class to yahoo mail. if i send a unicode email from non-Yahoo account to yahoo mail, it works correctly (display unicode chars correctly without any making change), but when i send from yahoo account to yahoo mail, it does not display characters correctly and i should change it's encoding to UTF8. can anybody help me to work-around this problem ? Please see my previous thread in this link. thanks in advancehttp://www.codeproject.com/KB/codegen/DatabaseHelper.aspx

Problem with incoming mail to SharePoint Library - what is wrong with this?

  
I configured my incoming mail to a SharePoint 2010 library according to these instructions. http://intellects.in/2010/04/04/configuring-sharepoint-2010-document-libraries-with-exchange-server-2010-to-receive-mails-from-internalexternal-world/ I'm able to receive mail at the Exchange mailbox set up for the document library, but am unable to receive the document in the library itself.  I'm thinking it's because I have a problem with my naming - but I'm not sure how to solve it: I have a SharePoint box and an Exchange box. I've configured the SMTP virtual server with default domain of  server.domain.com .  I've also assigned it an alias of domain2.net I've configured incoming email in SharePoint Central Administration to use the address of mylist@domain2.net so that users can have a friendly url for sending documents to lists and libraries. I've created an Attended Domain in Exchange 2010 and set up an email address policy that speicifes all mailboxes receive an domain2.net address.  I have an MX record for the domain2.net address with a DNS server pointing to the Exchange box. I've created an SMTP Send Connector that points to the FQDN server.domain.com of my virtual server on my SharePoint box. With that connector, I've chosen to route mail through the same FQDN of server.domain.com , that of my SharePoint/IIS SMTP Virtual Server box. When I confi

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

  
Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3

Microsoft.AnalysisServices.AdomdClient problem

  
I had a C# Winforms project referencing Microsoft.AnalysisServices.AdomdClient. It was working 100%. I upgarded MS SQL 2008 to R2. I also installed the relevant programs in the SQL2008 R2 feature pack. What happens now is after I add a reference to Microsoft.AnalysisServices.AdomdClient, I can add a using statement to the dll. If I type Microsoft, add a dot intellisence will give me 'AnalysisServices' and I can complete the statement. As soon as I build the project, I get a squirel below 'AnalysisServices' and the error message: Error 2 The type or namespace name 'AnalysisServices' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?) The version of Microsoft.AnalysisServices.AdomdClient is 10.0.0.0. The runtime version is v2.0.50727. The fileversion and product version is 10.50.1600.1. I work on a Windows Vista computer using Visual Studio Professional. I am realy desperate for help. I spend the entire weekend uninstalling and re-installing SQL 2008 R2, Visual Studio and the feature pack. All to no avail. I am not sure what forum to select.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend