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!
2  1638   ADezii 8,834
Recognized Expert Expert
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.
I think this is exactly what I needed. Thanks for the direction.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
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 for different
months which is dispalying as a column header.I want to break the values
weekly ,querterly
etc...can u provide idea or code?
|
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 quite repetitive.
What I had though of was a form that you select key settings and based on
that it writes out the letter in an intelligent manner:
For example:
|
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 address just great. Keeps the
mailman happy.
However The problem is that there are so many different envelope
|
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 information they want
on a particular report. Say for instance if using an invoice form, some
clients want to add discount columns and some don't. Is it possible to have
perhaps a "Setup Form" that tells a report what information is wanted on the...
|
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, etc). By "customized", I
mean I want complete control over the color of the messagebox, the
position/color/size of the buttons, etc.
Do I need to create a custom form from scratch, or is there a way to
subclass MessageBox? (I'm guessing I need to...
| | |
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 Reports .NET and
export to word .
I want to know the best approach , I have read about some
disadv of Word object model
|
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 execute a MailMerge to create mailing labels or
customized letters.
A label name known to MS Word MailMerge mailing label wizard may be used or
a template file containing the field names Line1 thru Line5 for each record
to be printed. If a...
|
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 companies records
management system.
I have looked at various methods, Crystal Reports seems a little over kill
for what I need, as I am only importing very basic data to the letter (name,
address, title date ect), I had a breif look at word...
|
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 create a mailmerge routine that accepts data from my SQL database and create a word doc that ce be previewed in the client browser. My OS is XP Pro and I am coding in VB.NET.
Protected Sub CreateWordMailMerge(ByVal strLabelName As String, _
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
