6 replies to this topic

[ihernandez]

First of all, i would like to apologize if there is already a thread on this topic. I'm currently working on a database for myseld, using Access, where we input customer info. We then need to populate a Report/Letter template, using the customer data we inputted earlier. What would i need to write up to be able to accomplish this?

[WingedPanther]

Is the Report/Letter template just an Access Report, or is it in an external program?

[ihernandez]

This letter is going to be an actual letter to be sent to an agency. i.e. "Dear (stored agency), Our mutual customer, (stored customer), came to me on, (stored date) regarding his credit score. I am currently helping him rebuild his credit, and would like his Credit Report. His information follows; (Stored name, Stored SSN, Stored Address, Stored employment). Any credit info regarding this person would be greatly appreciated." This is just a quick example, and just in case i'm not clear in the above example, when i say (stored agency, customer, etc) i mean a data point i saved into the database at a previous date. So i'm just inputting "x" into a blank, generic template.

[WingedPanther]

No, I mean HOW are you creating the letter. There is a difference between using Word, vs C# and email, vs Access Report, vs ...

[ihernandez]

see thats the question, i don't know how to create the letter. I would like to keep it all in access, just to minimize the different work mediums i'm using. So yes, i will be using Access report if possible. If report doesn't have the capability to do that, then what would you recommend?

[WingedPanther]

The reason I ask is Word has support for creating form-letters that pulls data from an Access database. Similarly, if you're sending emails, there are a number of options.

[ihernandez]

thank you thank you thank you.. that gives me a great lead to go on. I'll go look into that now, if i have any other questions, i'll come post on here. Your awesome bro.