473,435 Members | 1,774 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,435 software developers and data experts.

Mailing List Auto Content

Hi there,

I'm trying to get Access to create reports which will be sent out as
letters to a mailing list, these letters would be personalised for each
recipient, so that should they have a particular option (tick box)
selected then they get a particular passage of text inserted into the
letter.
Firstly is this possible? I know Word can create letters; however I
don't think that it can place different passages of text in to the
letter, for example it will just tell you that a check box is positive,
I need it to see that the tick box is selected and then picks a passage
of text to insert.

Thanks for any help,

Yours truly,

Village

Nov 28 '05 #1
1 1312
Yes, you can do this -- you will certainly not have the flexilibity you have
with Word, using the built-in Access controls.

Two ways that you can create the text in Access are:

Create it in the Format or Print event of the Detail Section, and put it
in a Text Box (or Text Boxes), or
Use an expression that creates the text as the Control Source of a Text
Box (or Text Boxes).

If you want more formatting flexibilty, you will need to use a Rich Text
Control. See MVP Stephen Lebans' site for a good, free one -- that comes
without any commitment of support (except whatever you can get here in the
newsgroups); there are commercial controls, such as FMS, Inc.'s
(http://www.fmsinc.com) for which support is available, too.

Larry Linson
Microsoft Access MVP

"Village" <al*********@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Hi there,

I'm trying to get Access to create reports which will be sent out as
letters to a mailing list, these letters would be personalised for each
recipient, so that should they have a particular option (tick box)
selected then they get a particular passage of text inserted into the
letter.
Firstly is this possible? I know Word can create letters; however I
don't think that it can place different passages of text in to the
letter, for example it will just tell you that a check box is positive,
I need it to see that the tick box is selected and then picks a passage
of text to insert.

Thanks for any help,

Yours truly,

Village

Nov 28 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: python-help-bounces | last post by:
Your message for python-help@python.org, the Python programming language assistance line, has been received and is being delivered. This automated response is sent to those of you new to...
1
by: Glabbeek | last post by:
I'm changing the layout of my site. Instead of using tables, I will use DIVs. It's working fine, except for 1 thing: In IE6 some DIVs are not the correct width. Mozilla and Opera are showing the...
9
by: Pierre Jelenc | last post by:
Is there a way to center (horizontally) a UL list of unknown width? I can put it in a DIV that's centered with "margin-left: auto; margin-right: auto;" but I then have to specify a width; otherwise...
3
by: yawnmoth | last post by:
I'm trying to center list elements in a webpage I'm working on, and setting margin-left to auto for ol (or ul) seems to prevent the number (or bullet) from displaying in IE6 (strict mode) and...
4
by: Andy M | last post by:
ALERT There is a person by the name of Mike Cox who's trying to turn this mailing list into a Big-8 newsgroup. Many of you know that this and most of the other postresql mailing lists are...
7
by: 3KWA | last post by:
Hi all, I tried to send a small mailing list using python today (2036 emails). For that purpose I looked in the doc for some code examples (I had never done it before). And I ended up writing...
0
by: marketing-python-bounces | last post by:
This mailing list has been retired. Please use the new Python Advocacy mailing list instead: http://mail.python.org/mailman/listinfo/advocacy Thanks!
2
by: divyac | last post by:
I have developed an address book using php and mysql.I have all the contacts list in a table with check boxes.Now that i want to create mailing labels for the checked contacts...i.e.,the arrangements...
26
by: =?iso-8859-1?q?Keld_J=F8rn?= Simonsen | last post by:
The Post Santa Clara mailing is now available from the WG14 web site at http://www.open-std.org/jtc1/sc22/wg14 I also updated some of the other information on the pages. Best regards Keld...
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
marktang
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,...
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...
0
agi2029
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,...
0
isladogs
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...
0
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...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.