Architecture :: Make Application Work With Ms Word Mail Merge?
Nov 9, 2010
I 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.
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?
Need 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?
I 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 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.
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.
I 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 have code that is supposed to do some database operations and then send an email through local iis smtp virtual server. All within one TransactionScope. It looks like
[Code]....
The second one where I use something similiar is
[Code]....
I want to notice that these events fire in the sequence they are shown. Now when there's an error, the db operations are rolled back, but the mail is sent anyway. I'm using Windows XP SP3, IIS 5.1, .Net 3.5, Visual Studio 2008. If I'm correct, TransactionScope uses MSDTC, right? I couldn't find anything about MSDTC working with smtp. Should it even work?
In myapplication i have done a thing like if some one purchase a tool for and if the license provided is for some few days (suppose for a week or an year).. How to send a mail automatically to the ID given by him before a day or a few days .
I would like to make a custom accordion, in which I have 2 panes, but where you couldn't open the second one until you clicked a validation button in the first one that would open the second...
I tried to just make a button that would hide the first pane but I cant get to make it work.
me 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
I 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.
I have a web application that is running on IIS within my company's domain, and is being accessed via intranet. I have this application sending out email based on some user actions. For example, its a scheduling application in part, so if a task is completed, an email is sent out notifying other users of that.
The problem is, the email works flawlessly in some cases, and not at all in others. I have a login.aspx page which sends out report emails when the page is loaded (its loaded once a day via windows task scheduler) - this always seems to work perfectly. I have an update page which is supposed to send email when text is entered and the "Update" button is clicked - this operation will fail most of the time. Both of these tasks use the same static overloaded method I wrote to send email using System.Net.Mail.
I have tried using gmail as my smtp server (instead of our internal one), and get the same results. I investigated whether having the local SMTP Service running makes any difference, and it doesn't seem to. Besides, since C# is server-side code, shouldn't it only matter whats running on the server, and not the client?Below is my code to send email.
I am making one website, where i have to autogeneated a mail for eg...I am on the leave for a week. If someone mailed me, an autogeneraed mail should go to that sender that i am not at a station for a week...
How to develop in web application..I am using C#,ASP 2.0.
I send automated mails to hotmail users. (thank you for your registration bla bla)Because plain text doesn't look attractive enough, I use HTML with images. The images reside on a public webserver.
As SMTP server I use the SMTP part of IIS 7.5 (windows 2008 R2). I have an SPF record setup in the DNS. I have also read http://tinisles.blogspot.com/2009/09/sending-dkim-email-from-c.html and found out that sending mail with the SMTP service and a DKIM signature cannot be done properly without an external commercial component. So I do not have such thing (yet).
Now that is all about my background and here is the problem:I have this in my HTML:
<a href="http://www.mydomain.com">click here</a>
But when users get am e-mail like that and view it in hotmail. (chrome, IE, safari etc.) and when they hover the link they will see that the url is http://www.mydomain.com but when they click on it. It redirects to:
what am I doing wrong? Is it an SMTP/IIS server setting? Did I forget something in my Asp.Net C# code when I have send the mail? Did I forget something in the DNS or HTML markup? The link works perfectly when I receive the mail in my Outlook 2010 where the domain is also added to the safelist.
EDIT If it seems to be all related to the antispam stuff in hotmail. Should I consider to buy: http://www.youtube.com/watch?v=98oc_5bjjkc