Hi everyone,
I'm a new member and relatively unsophisticated with macros. Would appreciate any pointers...
Situation: I've been setting up an online survey and the plan is to email ~500 of our company's clients with an invitation that will feature a unique link for each recipient. I have been told at the last minute that it is not permitted to upload clients' email addresses into the vendor's system without undergoing a very lengthy vendor review process. The workaround is that I can enter a unique number instead of email addresses and use the vendor's system to generate 500 unique links (which we can then map back on our side to identify the respondent). So I suppose what I need to do is to prepare a mail merge macro that will generate an Outlook message containing i) client's name, ii) unique URL, iii) corresponding sales person's email in CC field.
Can anyone suggest the correct approach, or point me towards a (dummy-friendly) resource?
I'm a new member and relatively unsophisticated with macros. Would appreciate any pointers...
Situation: I've been setting up an online survey and the plan is to email ~500 of our company's clients with an invitation that will feature a unique link for each recipient. I have been told at the last minute that it is not permitted to upload clients' email addresses into the vendor's system without undergoing a very lengthy vendor review process. The workaround is that I can enter a unique number instead of email addresses and use the vendor's system to generate 500 unique links (which we can then map back on our side to identify the respondent). So I suppose what I need to do is to prepare a mail merge macro that will generate an Outlook message containing i) client's name, ii) unique URL, iii) corresponding sales person's email in CC field.
Can anyone suggest the correct approach, or point me towards a (dummy-friendly) resource?