473,387 Members | 1,650 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Customized Letters Using Reports

Hi All!,

I've searched the fourms but I can't find anything specific to this. I'm trying to create customized letters using a data table containing names, addresses, order numbers etc.

I want a standard letter, but I want the name, address and order number to change for each letter (e.g. Dear Mr. Jones, Dear Mr.Smith, etc). I also want to print each letter and as the letter is printing, make the changes to each letter.

Any ideas of how to get started? A general direction and a hint of code should be all I need. Thanks!
Feb 2 '07 #1
2 1606
ADezii
8,834 Expert 8TB
Hi All!,

I've searched the fourms but I can't find anything specific to this. I'm trying to create customized letters using a data table containing names, addresses, order numbers etc.

I want a standard letter, but I want the name, address and order number to change for each letter (e.g. Dear Mr. Jones, Dear Mr.Smith, etc). I also want to print each letter and as the letter is printing, make the changes to each letter.

Any ideas of how to get started? A general direction and a hint of code should be all I need. Thanks!
What you are referring to sounds like a Mail Merge:
__1 Select the Table containing the relevant data within the Database Window.
__2 Make sure the Database Toolbar is visible. If not View, Toolbars, Database.
__3 Click the Office Links button on the Database Toolbar.
__4 Click Merge It with MS Word.
__5 Select the appropriate Option within the Microsoft Mail Merge Wizard then OK.
__6 You should now be in a Microsoft Word Document and you can work the options in the Mail Merge Toolbar which is now visible in Word.
__7 This should give you your customized letters, 1 for each Record in your Table but you must do the actual work. e.g. Insert standard text, merge fields, etc.
Feb 2 '07 #2
I think this is exactly what I needed. Thanks for the direction.
Feb 2 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: shovan | last post by:
I am creating a customized Purchase order report using asp. I have developed the reoprt as it is displaying the amount against a sales rep within a specific date range.now values are dispalaying...
3
by: Jay Best | last post by:
Hi there The story is as follows: I write up some pretty detailed reports on people, and what I am wanting to do is speed up the process as a proportion of the reports that I am writing are...
4
by: Bob | last post by:
Hi Everybody I have an Access 2000 database full of names and address, the usual thing. I am able to print out an A4 (UK paper size) letter that lines up with a window envelope and shows the...
3
by: Scott | last post by:
Hi Everyone, Does anyone know if it's possible to allow an end user of an Access DB to personalize the layout of their own reports. What we would like to do is allow them to select the...
1
by: Jean Bredeche | last post by:
Hi: I am trying to create customized confirmation/error/etc dialogs in my application. Up to now we've been using MessageBox.Show and passing it the various necessary flags (buttons, icons,...
2
by: srinivas | last post by:
HI All, I am planning to use word object model for printing auto letters for an ASP.NET application , I am not sure If its the best way to do it . The alternative would be use of Crystal...
2
by: Mikey | last post by:
Sample VB .NET source code to create mailing labels or customized letters using MS Word MailMerge This VB .NET source code will start MS Word and call methods and set properties in MS Word to...
3
by: Mick Walker | last post by:
Hi, I am looking for tutorials related to generating letters. If possible I would like these letters to be generated in Microsoft Word format, as that way they can be directly imported into my...
0
by: dbsog7777 | last post by:
I was trying to use the sample code below, but I encountered two errors: Application.DoEvents() and AutoText(entry). I am not sure how to correct the errors. I trying to use the sample code to...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.