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 1635 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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |