Easy question for 100 points!

I have an list  of email addresses and first names from people who have subscribed to my club.

How can I 'mail merge' my newsletters, so they use the recipient's first name?

ie
Dear Jonathan

Thank you for joining my club blah blah blah

Can I do this in a free programme? Can I do this sort of thing in a combination of Word 97 and Outlook Express?

Please let me know...

Kind regards


Jonathan
mindwaveAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

clsmasterCommented:
How are the E-Mail address and Names Stored and what are you gonna merge them to (E-Mail or printed document)
0
mindwaveAuthor Commented:
They are only stored in a members html guestbook format, so they have to be manually entered again so I don't care what I have to import them into.

I will be using it for mail merging outbound emails .

Thank you for your interest...

Jonathan
0
java_kevinCommented:
Do you mean that people subscribing to your club will have their names and email sent to you, then u put them together in some sort of a group name. Finally, you'll send articles to the members?
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

johnny99Commented:
I believe I have the answer, if I understand the question:

If you have a list where the names and the emails are distinguished by "<" characters, you can divide it up using Word's "Convert Text To Table" command (Table Menu). Simply use the "Separate Text At" option to split your list at each occurence of the "<" character...

For Example,

John Horner <johnny99@sydney.dialix.oz.au>
Some Guy <someguy@somedomain.com>

Splits up nicely into a table. Once you've separated them out, you should be able to use the fact that they're in a table, plus a bit of judicous Search/Replace to do what you need.

If not, there are some options in Excel 5, ("Text To Columns" from memory, don't have it on this machine) that may be able to help you...

If you can put the info into an HTML Table, then save as text, by the way, it will format the columns using whitepace, i.e. pushing the data around like so:

[viewed in Courier/Courier New these columns line up]

John Horner <johnny99@sydney.dialix.oz.au>  (nice guy)
Some Guy    <someguy@somedomain.com>        (complete dickhead)

Which may make it more susceptible to interpretation by Word/Excel.

johnny "Parse the salt" 99


0
mindwaveAuthor Commented:
Thanks johnny99 but that's not what I need...

I don't care HOW I extract the names and emails. What I need to know is, assuming I have the first names and email addresses, how do I go about emailing my newsletter to hundreds of people, each getting their first name as the example below shows...

=================================================
MoneySaver Smart Shopper Alert 10th May 1998
Issue #1    May 10, 1998
Save Money & Get Stuff Free!!
http://www.moneysaver.com.au
=================================================

Hi johnny99

Thank you for joining the MoneySaver Club. This newsletter & many more offfers is at
http://www.moneysaver.com.au/newsletters/

In your newsletter this week:

1) Wharf warfare! Have your say!
2) Enjoy the best coffee from Alan for free
3) Getting 2 cds for free
4) Save $20 on a tune-up at Kmart Tyre & Auto
5) Free Sausage Software and a $535 bonus!

etc. etc.

What database do I enter the names and email addresses to then 'mail merge' outward bound emails?


Thank you,

I really appreciate your helping me!

Jonathan :-)
0
johnny99Commented:
Hmmm,

I don't know of any software that will create and merge emails.

Word will of course create mail-merges, but then you'd have to cut and paste each one into an email. A databse would have the same problem.

My instinct is this can't be done with your resources, but I'd suggest you do a search in shareware.com or download.com with the right keywords and maybe there's something out there.

jh
0
java_kevinCommented:
I understand your question now. I also agree that no email software has been able to provide this function.

You maybe can download a database program from either of the two sites. Remember the www prefix.
0
mindwaveAuthor Commented:
Thanks guys.

I'm off the the shareware sites.

Jonathan
0
johnny99Commented:
Remember the www prefix, JK? Want to try it without? Not all sites have www at the start of them... : )

jjjhhh
0
hkpCommented:
If you use Word 97, you can use the mail merge dialog.

1. Select "Tools" menu.
2. Select "Mail Merge..."
3. Select "Get Data".
4. Select "Use Address Book"

Now, there can be some differences in system responses, but this is the basic concepts. You should be able to select the "Outlook Express" address book from a list of possible address books.

5. Create your main document, by inserting field "First_name" into the document. There's a mail merge toolbar for these operations. It will look something like this:

"Dear <<First_name>>

Thank you for joining my club blah blah blah

Can I do this in a free programme? Can I do this sort of thing in a combination of Word 97 and Outlook Express?

Please let me know...

Kind regards


Jonathan "


I hope this is what you needed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.