Solved

Easy question for 100 points!

Posted on 1998-05-08
10
193 Views
Last Modified: 2013-12-25
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
0
Comment
Question by:mindwave
  • 3
  • 3
  • 2
  • +2
10 Comments
 

Expert Comment

by:clsmaster
ID: 1855917
How are the E-Mail address and Names Stored and what are you gonna merge them to (E-Mail or printed document)
0
 

Author Comment

by:mindwave
ID: 1855918
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
 

Expert Comment

by:java_kevin
ID: 1855919
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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 2

Expert Comment

by:johnny99
ID: 1855920
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
 

Author Comment

by:mindwave
ID: 1855921
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
 
LVL 2

Expert Comment

by:johnny99
ID: 1855922
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
 

Expert Comment

by:java_kevin
ID: 1855923
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
 

Author Comment

by:mindwave
ID: 1855924
Thanks guys.

I'm off the the shareware sites.

Jonathan
0
 
LVL 2

Expert Comment

by:johnny99
ID: 1855925
Remember the www prefix, JK? Want to try it without? Not all sites have www at the start of them... : )

jjjhhh
0
 
LVL 3

Accepted Solution

by:
hkp earned 100 total points
ID: 1855926
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

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Read about why website design really matters in today's demanding market.
Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question