473,671 Members | 2,176 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Mail Merger from Access to word

on my frmCustomer form i would like a button that open up words and
runs a mail merger only with the data on on that form ( as on the mail
merger i just want the customer address for when i write a personal
letter to that customer only)

I know how to put a button to open a run a mail merger but i do not
know how to only make it mail merger the customer details on that form
and no other customers..
I have tried using qry and tables but i end up with all our customer
address mail merging and i only want one customer details to mail
merger
can any one help

Sep 11 '06 #1
6 1735
Nothing doing. Take the easy way out. Albert did all this for you....

http://www.members.shaw.ca/AlbertKal...rge/index.html

Couldn't be easier.

Sep 11 '06 #2
Do not understand his code and how its done, looking for a simler
verstion
pi********@hotm ail.com wrote:
Nothing doing. Take the easy way out. Albert did all this for you....

http://www.members.shaw.ca/AlbertKal...rge/index.html

Couldn't be easier.
Sep 11 '06 #3
Do not understand his code and how its done, looking for a simler
verstion
pi********@hotm ail.com wrote:
Nothing doing. Take the easy way out. Albert did all this for you....

http://www.members.shaw.ca/AlbertKal...rge/index.html

Couldn't be easier.
Sep 11 '06 #4

"Simon" <S.*******@shos .co.ukschreef in bericht news:11******** **************@ e3g2000cwe.goog legroups.com...
Do not understand his code and how its done, looking for a simler
verstion
Hmmm, you will need good eyes ...
simler verstion ?? You are in a hurry ??

IMO you should better ask a question about that code, and what *exactly* it is that you don't understand...

Arno R
Sep 11 '06 #5

Simon wrote:
Do not understand his code and how its done, looking for a simler
verstion

Why do you have to understand his code? Do you have to understand how
a car engine works in order to drive? How a telephone works in order
to use one? I don't. Been talking on telephones since I can't
remember when. I don't see how this is any different. If you follow
the instructions Albert gives, there's nothing more to it. But if you
want to mail merge the hard way, have at it.

Did you at least try it and follow his instructions? If you found the
page, he spells everythign out... so what's missing?

Sep 11 '06 #6

"Simon" <S.*******@shos .co.ukwrote in message
news:11******** **************@ i3g2000cwc.goog legroups.com...
Do not understand his code and how its done, looking for a simler
verstion
Actually, that code is designed to be used by people who don't know code.
While that web page of mine is a really piece of junk, that word merge is
download a LOT.

I have received letters from old ladies doing volunteer work for charities,
and they never seen, or written code before. They wrote me letters to thank
me for my solution (I am NOT making this up....I have received many emails
of thanks from people around the world..and they OFTEN tell me that they
don't know code, but were able to use my application with the step by step
instructions on the web page).

If you following the instructions, you can place a button on ANY of your
bound forms,and with ONE LINE of code, it will instantly word merge enabled.

One line of code is ALL you need to write. Behind the button, simple place
the following code

MergeSingleWord

That is it!!!...the merge system will take care of merging the ONE record
you are looking at. It also takes care of the template creation also.

So, I actually do agree that some efforts should be made to learn, and read
the code you use. However, in the mean time, you can use the code, and you
ONLY have to write ONE line of code to word merge enable any form with that
example.

Try downloading and running the sample. The sample has data, and just try
doing a merge with it. If the sample works, then try the step by step
instructions here on how to use this in your code.

You can download the sample here:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

And, step by step on how to use this in *existing* applcaitons is here:

http://www.members.shaw.ca/AlbertKal...rge/page2.html

While there is a LOT of solutions that use bookmarks, my solution actually
lets word do the merge (no book marks!!). Not only is this less code, but
this means that my code does NOT need to be modified for each new form, or
application that you use the code in. My code does not actually do the word
merge, and lets word do that part. My code is only a nice easy "wrapper"
interface for the features that exist now, and also just merges the ONE
record you are looking at.

My solution may not be what you are looking for, but you might want to give
the sample a try, since as far as I know, my solution is the ONLY solution
on the internet that allows you to word enable ANY form with ONE line of
code....

When I have time, I really should re-write the whole thing as a wizard..and
then you could word merge a form with NO code!!!

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
Sep 11 '06 #7

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

Similar topics

1
1639
by: Diane Yocom | last post by:
I have an ASP intranet application that is required to produce Word documents merged with data from a database. I originally looked at automating Word's mail merge capabilities, but nixed that idea since I learned it's not a good idea to try to automate Word on the server and I'd rather not have to worry about whether or not the user has Word on their machines. I, instead, decided to have the Word templates saved as RTF files and to...
8
9513
by: Squirrel | last post by:
Hi everyone, I've created a mail merge Word doc. (using Office XP) , the data source is an Access query. Functionality I'm attempting to set up is: User sets a boolean field to true for each person for whom a mail merge letter is desired. The query reads address info from the table for each record where is true.
9
4321
by: Neil Ginsberg | last post by:
I have a strange situation using Access to automate a Word mail merge. Using Access 2000 and Word 2000, the code opens Word, opens the document in Word, sets a table in the calling Access application as the data source, and then performs a merge. Everything works fine. However, when a user uses it in Access 2002 and Word 2002, an extra instance of the Access application is opened and remains open at the end. Sometimes it remains open
3
5579
by: Andy Davis | last post by:
I have set up a mail merge document in Word 2003 which gets its data from my Access 2000 database. I want to set up a button on a form that: 1. runs the query to provide the dat for the merge document in Word; 2. opens the document and runs the merge process for the new data. I have managed to write the code to perform step 1 ok, but I'm having trouble with step 2. It opens the word document fine but does not perform the mail merge of...
4
7466
by: pmhaupt2 | last post by:
I developed an Access 2003 program that will allow the user to produce a group of Word letters that merge with data records from an Access database. I created a mail merge Word document and associated it with a specific query in my Access database. My problem is that when I run my "create letters" button from an Access form, the program opens up Word correctly with the proper letter. However, the MailMerge toolbar in Word appears...
4
5446
by: lesperancer | last post by:
I have 3 tables (office97) tblQuote quoteNbr tblDetails ( quote : 1 <-> M: quoteDetails) quoteNbr detailLine product value
1
2664
by: ckirby | last post by:
I've inherited an application for creating mail merges from an Access 2003 ADP that needs an overhaul. To generate the mail merge , the app uses a shell command: result = Shell(str, vbHide) where str = "C:\Program Files\Microsoft Office\Office\Winword.exe " & letter & " /mmergeletter"
5
2059
by: Simon | last post by:
on my database i have a customers Table (tblCustomers) on the form of it (frmCustomers) i would like a button what will open up word and open up my comapny letter head template and then merger the customer details currently on the form into the Word letter so i can send an individual letter. Can any one help me
8
13328
by: Ron B | last post by:
Help!!! What am I doing wrong? I am working with Office 2003 and am trying to create a command button on an Access form that will create a mail merge in Word from an Access table. I want to make the mail merge seamless to the user so all they have to do is click on the command button and the letters are generated. For the button I created an event procedure with the following code: Private Sub RunLetters_Click()
0
8392
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,...
0
8912
Oralloy
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...
0
8819
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 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...
0
8669
tracyyun
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...
0
7428
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, 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...
1
6222
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 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...
0
5692
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();...
0
4222
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4403
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.