mail merge

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Word Training and help » Mail Merge

Mail Merge

resolvedResolved · Low Priority · Version 365

Edited on Tue 29 Aug 2023, 14:54

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

Thu 14 Sep 2023: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.07 secs.

✓ w3speedster