What is the best way to do this. I dont have access to the database since it is firewalled. It needs to be done throught the web interface. I can generate a csv file and plug it into the word document, but it seems cumbersome to me. Is there any better way to do this?
View 1 RepliesI am planning to create HR Management System using asp.net & sql server 2005. In this application we need to manage different kinds of Employee Documents like Offer letter,Salary certificate etc.. Now,What we need is we will store templates for these documents(ms word,excel) in the application and needs to genereate these documets corresponding to the selected employee like mail merge.
View 3 RepliesNeed to do a mail merge for ASP.NET application. Considered just programatically using word directly but this has liscening implications and is not recommended [URL] So was looking into openXML / Word Automation Services. But not sure if can easily achieve a mail merge via this?
View 1 RepliesI have all the data in excel/or some of database which has forexample to and from email addresses,names etc. I need to Mail Merge data into Word Document and this word document should be editable for any additions or modifications. Need to have the ability to type in the text or attach an attachment. should be filled with all the To,CC,subject fields from database/excel sheet and send an email. I need all this on a web page so i can distribute this webpage url to the user and he can get all this.
Is there any way to do this and if some one provide me some links to work on this or send me some code for this. I really donot have any idea and need to start from starch on how to accomplish this task.
I need to create some mail merge documents and was wondering if anyone knew the best way of doing this from asp.net. Currently I have set up .dot template files with bookmarks and then use COM to open these files pass the data and save. I can then stream the file to the users desktop. The issue i have is that to get this working when i release it is by installing Wrord on the server which I would prefer not to do.
way of passing data to word docs and then opening them to the user. The reason why i need to use word, is that the user needs to be able to modify the doc.
using asp.net 4 we do a lot of Word merges at work. rather than using the complicated conditional statements of Word i want to embed my own syntax. something like:
Dear Mr. { select lastname from users where userid = 7 },
Your invoice for this quarter is: ${ select amount from invoices where userid = 7 }.......
ideally, i'd like this to get turned into: string.Format("Dear Mr. {0}, Your invoice for this quarter is: ${1}", sqlEval[0], sqlEval[1]);
i'm looking for a way to implement a simple ail merge with iTextSharp library.
I have data stored in database (addresses) and a pdf template.
I need to create a single pdf file where each page contains one address.
How can i do this?
I'm having some difficulty merging multiple word documents together using Microsoft Office Interop Assemblies (Office 2007) and ASP.NET 3.5. I'm able to merge the documents, but some of my formatting is missing (namely the fonts and images). My current merge code is shown below.
private void CombineDocuments() {
object wdPageBreak = 7;
object wdStory = 6;
object oMissing = System.Reflection.Missing.Value;
object oFalse = false;
object oTrue = true;
string fileDirectory = @"C:documents";
Microsoft.Office.Interop.Word.Application WordApp = new Microsoft.Office.Interop.Word.Application();
Microsoft.Office.Interop.Word.Document wDoc = WordApp.Documents.Add(ref oMissing, ref oMissing, ref oMissing, ref oMissing);
string[] wordFiles = Directory.GetFiles(fileDirectory, "*.doc");
for (int i = 0; i < wordFiles.Length; i++) {
string file = wordFiles[i];
wDoc.Application.Selection.Range.InsertFile(file, ref oMissing, ref oMissing, ref oMissing, ref oFalse);
wDoc.Application.Selection.Range.InsertBreak(ref wdPageBreak);
wDoc.Application.Selection.EndKey(ref wdStory, ref oMissing);
}
string combineDocName = Path.Combine(fileDirectory, "Merged Document.doc");
if (File.Exists(combineDocName))
File.Delete(combineDocName);
object combineDocNameObj = combineDocName;
wDoc.SaveAs(ref combineDocNameObj, ref m_WordDocumentType, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing);
}
I don't care necessarily how this is accomplished. It could output via PDF if it had to. I just want the formatting to carry over.
I want to implemet mail merge with my on going project, I know well how send news letters to authorized clients, but need to do it with mail merge like the email from this forum.
View 1 RepliesI have requirement where I need to allow users to upload a Word document with place holders for certain fields which can be found in the database. This will be their template. For example the place holders might be prepended with @@ or something. For example
Dear @@Title @@Lastname
They then can grab a record and hit export to Word document. This will then let them choose the template. They can select the template and then click continue. I will then get the template and replace the @@Title with the title field in the database for the selected record. I am not sure where to start or what components I need to do this.
From my initial investigation it seems that I can do this with the new open XML standard for Office 2007. So perhaps I should read in the template and save all the contents to a db table somewhere. Then when the use wants to export I get the contents again and then do a search and replace for the @@ placeholders and link them properly. Then save the document to the output stream again which will then bring up the save dialog on their browser.
I am using ASP.Net MVC and am in a hosted environment. I was also maybe contemplating dynamically creating a new View type and dynamically creating new views when the user uploads a template. Not sure that this approach will work though.
I am trying to merge my vb.net Web application project with my c# mvc project not ideal at all but the project is too big to do it any other way.
View 1 Repliesme and my partner are distant programmer's and now after completing each of our module we want to merge it together and deploy our application , in future we can avoid this delay of merging into a single pc or server ..? so that we can upload or sync our work as soon as we completed it
View 2 RepliesI am making mailing system and i am using SQL MAIL service and i need to send mail to other server(application and mail server on different locations).so i some how i need to use queue systems. for example if i send 5000 mail then it should go in batch of 500-500. if i write code in core vb.net then user need to stay untill all batches complete. so some how i need a system by which user just click and mail address fetching and sending process works in background as well send in batch.
View 4 RepliesI have a requirement where i need to send mail from my application. I used the following code to send mail
[Code]....
The above code is neither working in my local system not showing error, but after the application has deployed in remote server(this is shared server) the code is working. What might be the problem?
I have a web application written in ASP.Net. When a user clicks a button in my application I want to open a MS Word file. How could I do this?
View 1 RepliesThis question deals mainly with streams in web application in .net. In my webapplication I will display as follows:
bottle.doc
sheet.xls
presentation.ppt
stackof.jpg
Button
I will keep checkbox for each one to select. Suppose a user selected the four files and clicked the button,which I kept under. Then I instantiate clasees for each type of file to convert into pdf, which I wrote already and converted them into pdf and return them. My problem is the clases is able to read the data form URL and convert them into pdf. But I don't know how to return the streams and merge them.
[code]....
I'm work'n in a ERP now and i'm suppose to assign duties to for the employees who will be working in three shifts.,wot i have planned is to have 2 Panels named A and B.,
1) Panel A with 3 div's named shift1,shift2 & shift3
2) Panel B comprising all the employees with their Employee's ID in a label
EVERYONE WOULD've WORKED WITH THE NEW YAHOO MAIL WHERE WE WILL DRAG OUR MAILS INTO OUR OWN FOLDERS
IS THIS POSSIBLE WITH ASP.NET 2.0 & C# IN WEB APPLICATION....???
Does'nt matter even if it is with JQUERY & AJAX !
I am working on word report in ASP.NET application.
In my application i do permit the user to dynamically generate the word document, so whatever changes user has made in word document.
i want back this changes in word document with that specifc user.
so how can i attach the event in word document?
what user close the opened word application then my code should execute to read the word file .
I am in need of making a web application that has the ability to load word documents from sql server(onto the web page), edit them, then save them back to the database. I've read a couple of articles that show that you can integrate MS Word into .NET, so it looks like it is possible. My question is whether or not there are major security holes in doing so. Since I want to be able to save my changes back into the database, I am a little hesitant on what certain people might try to exploit if I do this.
View 3 RepliesI have this text in a file that is supposed to transmit to new registrants on my site after they successfully complete the CreateUserWizard:
Dear '<% UserName %>',
Thank you for registering with our site!
Here are your user ID and password for accessing the site:
User ID: <% UserName %>
Password: <% Password %>
I have this text in the CreateUserWizard...
[Code]....
In my application i have two textboxes txt1 and txt2, and a push button btn1, when the user enters his USERNAME and PASSWORD and press the push button, the application should directly connect to gmail and has to login into his gmail Account....
[code]....
and also for gmail with same code.
but i dont khonw how can i distribute this for my web mail account because i dont khow urls and id and name that must give in the code
while trying to send the mail from asp application i get the following error message" Transport failed to connect to server"here is my code below:
[Code]....
Does anyone have a solution
I want to send the mail in my .NET Application version 4.0. But i am getting the error as Host is not present and some times as Smtp authentication error (SMTP socket Exeception).
how to send a mail using .NET application.
Created a thread in master page and have called email function to select mails which are not sent from database. Mails are going but the problem is whenever a user clicks mails are going multiple times.
View 1 RepliesI am using asp.net with c#. I want to send free email through my asp.net application. so how could i develop and implement in my web application ?
View 1 Replies