473,721 Members | 1,708 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How can I create an 'email merge?'

Hi there,

In work, we often mail merge letters and post them to contacts. But more
and more, we've been emailing information to people instead. So far, I've
been writing a single generic email, then copying and pasting the email
addresses into the address fields. I start the email off with 'Dear all...'

But is there a way to 'email merge' this directly into outlook emails, in
the same way we do for normal printed letters? This copying and pasting is
getting to be a bit tedious, especially when I've got hundreds of contacts,
and need to send emails to batches of 30 people at once. To get all the
email addresses together, I've been doing a catalogue mail merge of the
email addresses in Word, then copying and pasting groups of email addresses
into the emails.

I would love to have all the emails 'email merged,' so they started with
'Dear Fred...' or whatever, to give them a more personal touch, and so I
could have a single email for each person, rather than a single email for
lots of people at once.

Thank you for any help or advice.

Regards,

Stephen
Nov 12 '05 #1
5 4572
stemc © wrote:
Hi there,

In work, we often mail merge letters and post them to contacts. But
more and more, we've been emailing information to people instead. So
far, I've been writing a single generic email, then copying and
pasting the email addresses into the address fields. I start the
email off with 'Dear all...'

But is there a way to 'email merge' this directly into outlook
emails, in the same way we do for normal printed letters? This
copying and pasting is getting to be a bit tedious, especially when
I've got hundreds of contacts, and need to send emails to batches of
30 people at once. To get all the email addresses together, I've
been doing a catalogue mail merge of the email addresses in Word,
then copying and pasting groups of email addresses into the emails.

I would love to have all the emails 'email merged,' so they started
with 'Dear Fred...' or whatever, to give them a more personal touch,
and so I could have a single email for each person, rather than a
single email for lots of people at once.

Thank you for any help or advice.

Regards,

Stephen


I've a client that wants to go from a Word merge to an email merge. In
Access you can send an object to email but you'd have to send the report
seperately for each person (a manual merge). I thought that perhaps
there would be a way of sending the email to Word with the usual merge
and somehow get Word to merge the document using the email address to
send to each person... but I haven't go to that point to try it!

Would be interested in some methods of doing this myself. It would be a
nice feature to add to Access!
--
regards,

Bradley
Nov 12 '05 #2

"Bradley" <br*****@REMOVE THIScomcen.com. au> wrote in message
news:40******** @nexus.comcen.c om.au...
| stemc © wrote:
| > Hi there,
| >
| > In work, we often mail merge letters and post them to contacts. But
| > more and more, we've been emailing information to people instead. So
| > far, I've been writing a single generic email, then copying and
| > pasting the email addresses into the address fields. I start the
| > email off with 'Dear all...'
| >
| > But is there a way to 'email merge' this directly into outlook
| > emails, in the same way we do for normal printed letters? This
| > copying and pasting is getting to be a bit tedious, especially when
| > I've got hundreds of contacts, and need to send emails to batches of
| > 30 people at once. To get all the email addresses together, I've
| > been doing a catalogue mail merge of the email addresses in Word,
| > then copying and pasting groups of email addresses into the emails.
| >
| > I would love to have all the emails 'email merged,' so they started
| > with 'Dear Fred...' or whatever, to give them a more personal touch,
| > and so I could have a single email for each person, rather than a
| > single email for lots of people at once.
| >
| > Thank you for any help or advice.
| >
| > Regards,
| >
| > Stephen
|
| I've a client that wants to go from a Word merge to an email merge. In
| Access you can send an object to email but you'd have to send the report
| seperately for each person (a manual merge). I thought that perhaps
| there would be a way of sending the email to Word with the usual merge
| and somehow get Word to merge the document using the email address to
| send to each person... but I haven't go to that point to try it!
|
| Would be interested in some methods of doing this myself. It would be a
| nice feature to add to Access!
| --
| regards,
|
| Bradley

If you find anything out, be sure to let me know Bradley! It sounds like it
would be a great feature, and it's certainly one which I could make use of.

Thanks,

Ste


Nov 12 '05 #3
"stemc ©" <st*@sm9DELETE. co.uk> wrote in message news:<2g******* *****@uni-berlin.de>...
"Bradley" <br*****@REMOVE THIScomcen.com. au> wrote in message
news:40******** @nexus.comcen.c om.au...
| stemc © wrote:
| > Hi there,
| >
| > In work, we often mail merge letters and post them to contacts. But
| > more and more, we've been emailing information to people instead. So
| > far, I've been writing a single generic email, then copying and
| > pasting the email addresses into the address fields. I start the
| > email off with 'Dear all...'
| >
| > But is there a way to 'email merge' this directly into outlook
| > emails, in the same way we do for normal printed letters? This
| > copying and pasting is getting to be a bit tedious, especially when
| > I've got hundreds of contacts, and need to send emails to batches of
| > 30 people at once. To get all the email addresses together, I've
| > been doing a catalogue mail merge of the email addresses in Word,
| > then copying and pasting groups of email addresses into the emails.
| >
| > I would love to have all the emails 'email merged,' so they started
| > with 'Dear Fred...' or whatever, to give them a more personal touch,
| > and so I could have a single email for each person, rather than a
| > single email for lots of people at once.
| >
| > Thank you for any help or advice.
| >
| > Regards,
| >
| > Stephen
|
| I've a client that wants to go from a Word merge to an email merge. In
| Access you can send an object to email but you'd have to send the report
| seperately for each person (a manual merge). I thought that perhaps
| there would be a way of sending the email to Word with the usual merge
| and somehow get Word to merge the document using the email address to
| send to each person... but I haven't go to that point to try it!
|
| Would be interested in some methods of doing this myself. It would be a
| nice feature to add to Access!
| --
| regards,
|
| Bradley

If you find anything out, be sure to let me know Bradley! It sounds like it
would be a great feature, and it's certainly one which I could make use of.

Thanks,

Ste



Found a free program on www.download.com that seems to have all the
features you need. It's called PIMEX MailExpress. You'll need to
export your email address and name data to a text file so that the
program can read it but once thats set up it should be OK.

It has good reviews so it may be worth a look.
Nov 12 '05 #4

"Charlie" <ma********@yah oo.co.uk> wrote in message
news:42******** *************** **@posting.goog le.com...
| "stemc ©" <st*@sm9DELETE. co.uk> wrote in message
news:<2g******* *****@uni-berlin.de>...
| > "Bradley" <br*****@REMOVE THIScomcen.com. au> wrote in message
| > news:40******** @nexus.comcen.c om.au...
| > | stemc © wrote:
| > | > Hi there,
| > | >
| > | > In work, we often mail merge letters and post them to contacts. But
| > | > more and more, we've been emailing information to people instead.
So
| > | > far, I've been writing a single generic email, then copying and
| > | > pasting the email addresses into the address fields. I start the
| > | > email off with 'Dear all...'
| > | >
| > | > But is there a way to 'email merge' this directly into outlook
| > | > emails, in the same way we do for normal printed letters? This
| > | > copying and pasting is getting to be a bit tedious, especially when
| > | > I've got hundreds of contacts, and need to send emails to batches of
| > | > 30 people at once. To get all the email addresses together, I've
| > | > been doing a catalogue mail merge of the email addresses in Word,
| > | > then copying and pasting groups of email addresses into the emails.
| > | >
| > | > I would love to have all the emails 'email merged,' so they started
| > | > with 'Dear Fred...' or whatever, to give them a more personal touch,
| > | > and so I could have a single email for each person, rather than a
| > | > single email for lots of people at once.
| > | >
| > | > Thank you for any help or advice.
| > | >
| > | > Regards,
| > | >
| > | > Stephen
| > |
| > | I've a client that wants to go from a Word merge to an email merge. In
| > | Access you can send an object to email but you'd have to send the
report
| > | seperately for each person (a manual merge). I thought that perhaps
| > | there would be a way of sending the email to Word with the usual merge
| > | and somehow get Word to merge the document using the email address to
| > | send to each person... but I haven't go to that point to try it!
| > |
| > | Would be interested in some methods of doing this myself. It would be
a
| > | nice feature to add to Access!
| > | --
| > | regards,
| > |
| > | Bradley
| >
| > If you find anything out, be sure to let me know Bradley! It sounds
like it
| > would be a great feature, and it's certainly one which I could make use
of.
| >
| > Thanks,
| >
| > Ste
|
|
|
|
| Found a free program on www.download.com that seems to have all the
| features you need. It's called PIMEX MailExpress. You'll need to
| export your email address and name data to a text file so that the
| program can read it but once thats set up it should be OK.
|
| It has good reviews so it may be worth a look.

Thanks for that. I did download it and try it, but it didn't quite work how
I was wanting.

However, I did find a program that I liked:
http://www.fairlogic.com/worldcast/

Thanks,

Ste
Nov 13 '05 #5
Ste & the rest,
Word will do this. It's been part of the Word object model since at least
Word 97. With Office XP there is a wizard that will walk you through the
steps to doing this. Took me about three minutes to set up (and I was
watching the World Series of Poker while playing with it).

"ste©" <Co************ **************@ sm9.co.uk> wrote in message
news:2k******** ****@uni-berlin.de...

"Charlie" <ma********@yah oo.co.uk> wrote in message
news:42******** *************** **@posting.goog le.com...
| "stemc ©" <st*@sm9DELETE. co.uk> wrote in message
news:<2g******* *****@uni-berlin.de>...
| > "Bradley" <br*****@REMOVE THIScomcen.com. au> wrote in message
| > news:40******** @nexus.comcen.c om.au...
| > | stemc © wrote:
| > | > Hi there,
| > | >
| > | > In work, we often mail merge letters and post them to contacts. But | > | > more and more, we've been emailing information to people instead.
So
| > | > far, I've been writing a single generic email, then copying and
| > | > pasting the email addresses into the address fields. I start the
| > | > email off with 'Dear all...'
| > | >
| > | > But is there a way to 'email merge' this directly into outlook
| > | > emails, in the same way we do for normal printed letters? This
| > | > copying and pasting is getting to be a bit tedious, especially when | > | > I've got hundreds of contacts, and need to send emails to batches of | > | > 30 people at once. To get all the email addresses together, I've
| > | > been doing a catalogue mail merge of the email addresses in Word,
| > | > then copying and pasting groups of email addresses into the emails. | > | >
| > | > I would love to have all the emails 'email merged,' so they started | > | > with 'Dear Fred...' or whatever, to give them a more personal touch, | > | > and so I could have a single email for each person, rather than a
| > | > single email for lots of people at once.
| > | >
| > | > Thank you for any help or advice.
| > | >
| > | > Regards,
| > | >
| > | > Stephen
| > |
| > | I've a client that wants to go from a Word merge to an email merge. In | > | Access you can send an object to email but you'd have to send the
report
| > | seperately for each person (a manual merge). I thought that perhaps
| > | there would be a way of sending the email to Word with the usual merge | > | and somehow get Word to merge the document using the email address to | > | send to each person... but I haven't go to that point to try it!
| > |
| > | Would be interested in some methods of doing this myself. It would be a
| > | nice feature to add to Access!
| > | --
| > | regards,
| > |
| > | Bradley
| >
| > If you find anything out, be sure to let me know Bradley! It sounds
like it
| > would be a great feature, and it's certainly one which I could make use of.
| >
| > Thanks,
| >
| > Ste
|
|
|
|
| Found a free program on www.download.com that seems to have all the
| features you need. It's called PIMEX MailExpress. You'll need to
| export your email address and name data to a text file so that the
| program can read it but once thats set up it should be OK.
|
| It has good reviews so it may be worth a look.

Thanks for that. I did download it and try it, but it didn't quite work how I was wanting.

However, I did find a program that I liked:
http://www.fairlogic.com/worldcast/

Thanks,

Ste

Nov 13 '05 #6

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

Similar topics

3
5390
by: Richard Fritzler | last post by:
I was given the task of designing a complete web based document prep system. In simplest terms (using a msword explanation) create a database of merge fields, and a library of templates. Allow the webuser to select the template, merge his DB record, and produce a formatted document that can be printed or downloaded. We need to do this without specialized software on the client, since it will be universally available to webusers. We...
3
479
by: di | last post by:
I have a Access Database, and I would like to create a word document that (preferable would filter)links to ACCESS table or query. I would like to print the word document on the filtered record that I have selected in Access. for example if I have customer number (201) that I would like to merge over to a Word document. The word document is a template that I would like to use regularly. Thanks so Much for anyone that can WALK me thru...
0
1329
by: DS | last post by:
Hi Guys (and ladies): I have a parameter query in A2K that asks for records based on certain criteria. It returns the name and address fields of each record. I usually get about 5 to 10 records from the query. I then use this query as the basis for a Word mail merge but instead of printing out letters, I email the records. The problem is that when I do a merge and ask it to merge for email, it lumps all the records into one email. Any...
2
13532
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...
27
3787
by: max | last post by:
Hello, I am a newbye, and I'm trying to write a simple application. I have five tables with three columns; all tables are identical; I need to change some data in the first table and let VB updates the same data in all other four tables in the right places. I know it would be possible by using the ForeignKeyConstraint object. I have created the tables using the DataSet Visual Tool and I know it doesn't create any ForeignKeyConstraint obj....
2
2935
by: Bill Millerd | last post by:
I am performing a mail merge and generating e-mails automatically from an Access Table. When I click the "Merge to Email" icon in Word, the resulting dialog box only allows me to select one field from my Access table in the "To:" field. I have 2 fields in my Access table that I need to send an e-mail to. Is there any VB code that can perform the Mail Merge to e-mail that is perhaps more flexible than the standard functionality?
9
1841
by: Academia | last post by:
ContextMenu has a Popup event but MainMenu does not. I need Popup with MainMenu. Do you know anyway to simulate it? Thanks in advance
1
4882
by: vdosev | last post by:
I have MS Access Database clients database. When client places an order – I have developed VBA code to create an email confirming the details of the order. Everything is coded, but the body text is concatenation of multiple notepad files and fields from the database. I need to improve the code to be able to send html format email based on a template – it can be Word Template, or Outlook Template… something like Mail Merge in Word, but...
0
2542
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, _ ...
0
8844
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, 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...
0
8731
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,...
1
9132
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,...
0
9067
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...
1
6672
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
4487
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
4755
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3191
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
2
2578
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.