Ryan has attended:
Excel Advanced course
Mail Merge
Hello,
I am attempting to create a mail merge with a list of data sets on Word. I am however having trouble getting the merge to allow one email with all the information on there. It is trying to send 7 emails to the same recipient each with one set of data whereas I would like it to send 1 email with all 7 sets of data ideally.
Many thanks
Ryan
RE: Mail Merge
Hello Ryan,
Thank you for your post. In order for us to better help you with your question, please could you tell us more about your merge:
* Is the merge meant to go out to one one recipient or many?
* What is the source of your recipient list used to create the merge (e.g. Excel)?
* If the recipient list is indeed external, do the column headers match those in the Word Merge Wizard?
* Please tell us more about the 7 data sets to be included in the merge?
Kind regards
Marius Barnard
STL
RE: Mail Merge
Hi Marius,
Thank you for your response to me on this. To answer your questions:
1) The merge is to go out to multiple recipients but in the sets of data that I mention, this is all for the same recipient
2 & 3) The Source of the recipient list is an excel file and the columns do all match up. The data pulls through correctly as well, it's just that it tries to send 7 separate emails rather than the single one.
4) The 7 data sets are fields that are being used to display reference numbers that we use in our internal system as well as some deadlines to go along with any responses.
Many thanks,
Ryan
RE: Mail Merge
Hello Ryan,
Apologies for the delay in my response. I have spoken to some fellow trainers about your issue, but unfortunately, without actually seeing and understanding all the parts making up the merge myself, I'm not able to accurately give you a good solution to your question.
I'm sorry that we can't be of more help to you.
Kind regards
Marius
