Creating formal letter

[BIGGY]

I need to create a basic program that puts selected items into a letter. This letter would contain a scanned image for a header, then selected company names as the body, and finally a concluding line which is already entered into a table. If I want to do this without using Word mail merge, can I do all of this within a form? And can anyone point me in the direction to get rolling in terms of creating a letter?

Some more info: User should be allowed to select one of several letters (for each of our companies). Doing so I plan to bring up a selection of companies to select from for the body...credit references (a table) and bank references (another table). Each table will have all of our credit references and bank references. The user can then select which credit and bank references they would like (max of 4 credit, and 1 bank). So to do this my best guess is to build a temporary table which will hold all of the information the user selected, then use that table to fill the form? Since we have multiple companies, there will be multiple forms with the proper logo and signatures scanned in.

Does it sound like I'm off on the right track so far? Any input is greatly appreciated

 

[statsman]

Sounds to me like you would be better off doing it as a report.
Put your scanned letterhead into the report header along with the return address etc.
Write the text part of your letter as a label and just insert the things you already have in tables as a text box.
You may have some problems with justification but you can work around that with the TRIM function
Good luck

 

[The_Doc_Man]

Look into MailMerge as a way to do this.

Make more than one template file. Each distinct file can have a distinct logo and/or letter head. Even if they have the same body format. Select the template based on the same criteria you would have used to select the logo to load. I.e. if it is the Smith and Jones letterhead, use the template that contains the Smith and Jones logo already, rather than one that is so bland that you have to load the log as well as everything else. Trust me, the more work you can do ahead of time, the better off you are.

You of course need WORD to make it work.

If you used any other tool (say, Notepad or Wordpad), that logo picture would be tougher to manage.

 

[BIGGY]

I know mail merge is one option, but to help further "idiot" proof the program...was looking to keep everything all in one. I've done it with mail merge in the past and was requested to keep it all in Access this time which shouldn't be all that difficult is my guess. But I'll look into doing it as a report rather than a form instead.