Mail Merge

Resolved · Low Priority · Version 365

Thu 24 Aug 2023, 14:09 Edited on Tue 29 Aug 2023, 14:54 Delegate Ryan said...

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

Tue 29 Aug 2023, 13:13 Trainer Marius said...

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

Tue 29 Aug 2023, 14:55 Delegate Ryan said...

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

Thu 7 Sep 2023, 14:47 Trainer Marius said...

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

Thu 14 Sep 2023: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Word tip:

Create Blank Lines in Lists

If you in the middle of writing a numbered or bulleted list you may want to insert a blank line between the points to make the list more readable. To do this:

While in the middle of typing a list:

Press Shift+Enter and your cursor will stay in the list and move down a line without inserting another bullet or number.

Press Enter and a new bullet or number will form.

This can be useful in case your lists contain items several sentences long, as blank lines between the items may make your lists more readable.

View all Word hints and tips