Question about composing a CCBill affiliate e-mail - GoFuckYourself.com

PartyLikeAPornstar · 07-01-2007, 10:05 AM

I was wondering how some programs send out affiliate e-mails and manage to include the name of the person they're e-mailing in the salutation. Is there some kind of variable that you can use when composing the e-mail from CCBill's web admin? Im also looking for a way to insert the actual affiliate number into the e-mail as well. How do I do that?

BV · 07-01-2007, 10:08 AM

you can't do it with CCBill's current affiliate email system.

Maybe in their new system coming out soon, but not yet.

teenfeetcash · 07-01-2007, 10:29 AM

Easy

Assuming you have Outlook, Word and Excel installed . . . .

1) Download a members report in .csv format
2) Open word and select Mailings>Start Mail Merge>Email Messages
3) Then Choose Select Recipients>Use Existing List
4) Browse and select .csv file
5) Write your email template, when you want to add a name select Insert Merge Field>Name
6) Your Template will have the characters <<name>> making your main template "Dear <<name>>”
7) Do the same for your affiliates field select Insert Merge field>Affiliates you will get the text <<affiliates>> appear.
8) You will now have a template with <<name>> for the names and <<affiliates>> for the affiliate codes.
9) Preview the individual email by selecting "Preview results" and selecting the “<” and “>” arrows to flick through the individual mails.
10) Once you are happy select Finish & Merge>Send Email Messages
11) Select the EMAIL field when the box appears, enter a subject and click OK
12) The mails will be sent through the default mail account in outlook

This is how I do it to send personalised emails to affiliates with their own link codes!!

I hope this helps!!

PartyLikeAPornstar · 07-01-2007, 10:33 AM

Quote:

Originally Posted by teenfeetcash

Easy

Assuming you have Outlook, Word and Excel installed . . . .

1) Download a members report in .csv format
2) Open word and select Mailings>Start Mail Merge>Email Messages
3) Then Choose Select Recipients>Use Existing List
4) Browse and select .csv file
5) Write your email template, when you want to add a name select Insert Merge Field>Name
6) Your Template will have the characters <<name>> making your main template "Dear <<name>>?
7) Do the same for your affiliates field select Insert Merge field>Affiliates you will get the text <<affiliates>> appear.
8) You will now have a template with <<name>> for the names and <<affiliates>> for the affiliate codes.
9) Preview the individual email by selecting "Preview results" and selecting the ?<? and ?>? arrows to flick through the individual mails.
10) Once you are happy select Finish & Merge>Send Email Messages
11) Select the EMAIL field when the box appears, enter a subject and click OK
12) The mails will be sent through the default mail account in outlook

This is how I do it to send personalised emails to affiliates with their own link codes!!

I hope this helps!!

Well that sux. I dont have any of those programs installed. Thats a lot of work! Thanks for the detailed answer though

teenfeetcash · 07-01-2007, 10:37 AM

A lot of work for the first batch but then you will have the template (you would save the word template) for future mailings as you just change the text of the mail.

Oh you can download a trial version of Office to see if it works for you at : http://office.microsoft.com and dowload a 60 day trial ;)

Violetta · 07-01-2007, 11:43 AM

Hi there.. I have a script that I am using for that purpose! Hit me up on icq!

Love your program, but I dont think you are allowed to have 2 banners in your sig. And not a big one like that either. 120x60 I think is the rule

07-01-2007, 10:05 AM	#1
PartyLikeAPornstar Registered User Join Date: Jun 2007 Posts: 66	Question about composing a CCBill affiliate e-mail I was wondering how some programs send out affiliate e-mails and manage to include the name of the person they're e-mailing in the salutation. Is there some kind of variable that you can use when composing the e-mail from CCBill's web admin? Im also looking for a way to insert the actual affiliate number into the e-mail as well. How do I do that? __________________ aka Jayden ISeekYou:[427][848][401] CheeseFrogFlow -- Affiliate Support "If you got a problem, yo I'll solve it..."

07-01-2007, 10:29 AM	#3
teenfeetcash Confirmed User Join Date: Jun 2007 Posts: 527	Easy Assuming you have Outlook, Word and Excel installed . . . . 1) Download a members report in .csv format 2) Open word and select Mailings>Start Mail Merge>Email Messages 3) Then Choose Select Recipients>Use Existing List 4) Browse and select .csv file 5) Write your email template, when you want to add a name select Insert Merge Field>Name 6) Your Template will have the characters <<name>> making your main template "Dear <<name>>” 7) Do the same for your affiliates field select Insert Merge field>Affiliates you will get the text <<affiliates>> appear. 8) You will now have a template with <<name>> for the names and <<affiliates>> for the affiliate codes. 9) Preview the individual email by selecting "Preview results" and selecting the “<” and “>” arrows to flick through the individual mails. 10) Once you are happy select Finish & Merge>Send Email Messages 11) Select the EMAIL field when the box appears, enter a subject and click OK 12) The mails will be sent through the default mail account in outlook This is how I do it to send personalised emails to affiliates with their own link codes!! I hope this helps!! __________________ Got Foot Traffic? http://www.teenfeetcash.com

07-01-2007, 10:37 AM	#5
teenfeetcash Confirmed User Join Date: Jun 2007 Posts: 527	A lot of work for the first batch but then you will have the template (you would save the word template) for future mailings as you just change the text of the mail. Oh you can download a trial version of Office to see if it works for you at : http://office.microsoft.com and dowload a 60 day trial ;) __________________ Got Foot Traffic? http://www.teenfeetcash.com

07-01-2007, 11:43 AM	#6
Violetta Affiliate Join Date: Jul 2004 Posts: 28,735	Hi there.. I have a script that I am using for that purpose! Hit me up on icq! Love your program, but I dont think you are allowed to have 2 banners in your sig. And not a big one like that either. 120x60 I think is the rule __________________ M&A Queen

07-01-2007, 10:08 AM	#2
BV wtf Industry Role: Join Date: Sep 2001 Location: Bikini State, FL USA Posts: 10,914	you can't do it with CCBill's current affiliate email system. Maybe in their new system coming out soon, but not yet.