Jamie--you just saved me hours with the mail merge video instructions! I would have spent hours emailing all of my customers today (asking about their holiday hours) versus a five minute process (once I had them in an excel sheet). Your instructions were so clear and comprehensive. Thank you!!!
Hi, I’ve used the merge that you reviewed and had success with the email. If I want to save each document separately on my desktop, do I need to download a document splitter? For example, student progress reports. I email them to each family, but also want to save each one as a separate document. Thanks for your videos.
Great video and helpful tutorial. Question: is there a method for attaching individual pdf tailored for each recipient? Thank you. N.B., I’ve subscribed to your channel and I’m looking forward to your videos. :)
Timing is everything, as they say ;) I’m striving to find a solve for unique attachments with mail merge … today. May have to resort to manual emails with each attachment one last time and await your new video on this topic. Thanks for your swift reply! Cheers.
I could get the word merge document working but when I use HTML option to email, I did not receive the emails neither found in the SENT folder. I am using the new Outlook Office 365. Any idea of what prevent me from getting the emails? I used my own email to receive all emails to test if it works well for me.
can this work with a dynamic excel? eg if that first sheet neesd to be filtered to show a different list of contacts, does it create any complications?
Great video. Quick question please, how do I check which outlook email account is linked to the Word document? I've tried email the merged document but it's not showing in any of my Outlook 'Sent' boxes. Thanks!
How would I keep it from adding extra line items when I have multiple fields to add across the database? For instance I have taxes, prices, totals, but all vary per document, my problem is that all of the fields that I add, even if they're blank, they add a break and even though there's no data there I end up with a 3 page document of blank space rather than just populating the specific fields when there is data present. Is there a way to optimize this?
What if I need to combine a mr and ms from separate rows in the spreadsheet to the same letter? The common denominator between them On the spreadsheet is the same letter reference code.
In your word document, if you go to the Mailings header, and find the option that says "Edit Recipient List", you should be able to uncheck the checkboxes for the people you don't want to send an email to.
How would you delay delivery of these emails? I am going to send out students' grades and I want to be off the school premises by the time they receive their results!
I want to mail merge parents with results of student's, however, I'm having trouble with the percentage column. eg. 60% How can you mail merge results?
Hi techer, good but can you help me why i couldn’t send out via my web outlook365? Even I switched my outlook 365 to windows base but still in vain. Could you pls help on this.
Well, I like your easy to understand teaching………here’s my problem……….why can’t i find MY Excel document headings?????????? I’m only seeing the preset headings in Word………I even tried to use their F1, F2, F3, etc and got nothing but blank documents. Windows 7 used to let me see my document headings!!!! Now I have 365 and am going to scream…………I hope you can help me before the top of my head pops off!!!!!!
I've been using this for decades. I can't believe ALL teachers don't know this. Great video!
Glad it was helpful!
Jamie--you just saved me hours with the mail merge video instructions! I would have spent hours emailing all of my customers today (asking about their holiday hours) versus a five minute process (once I had them in an excel sheet). Your instructions were so clear and comprehensive. Thank you!!!
You are very welcome!
This video was so great, very clear and easy to go along with the video. I have 21 letters to send out tomorrow, THANK YOU!
I have watched so many videos tyring to understand Mailmerge and I finally understood after your video. I am so grateful for your video. thank you!
Most useful - I was having difficulty with emailing to "groups" in the new Outlook. This looks like a much better way to do it. Thank you. David
You’re welcome!
Very helpful. Thank you!
Thanks You ! I learned a lot from you videos.
This was amazing! Thank you so much!
You're welcome! I'm happy it helped.
Thank you!! Excellent tutorial!
You’re welcome! Glad you liked it.
Hi, I’ve used the merge that you reviewed and had success with the email. If I want to save each document separately on my desktop, do I need to download a document splitter? For example, student progress reports. I email them to each family, but also want to save each one as a separate document. Thanks for your videos.
Great tutorial. Can this also be done in Google Docs?
Great video and helpful tutorial. Question: is there a method for attaching individual pdf tailored for each recipient? Thank you. N.B., I’ve subscribed to your channel and I’m looking forward to your videos. :)
Thanks! I was going to create another video about dealing with attachments.
Timing is everything, as they say ;) I’m striving to find a solve for unique attachments with mail merge … today. May have to resort to manual emails with each attachment one last time and await your new video on this topic. Thanks for your swift reply! Cheers.
Great, very helpful. Thank you so much for your contribution.
Thank you so much this was super helpful!!
I could get the word merge document working but when I use HTML option to email, I did not receive the emails neither found in the SENT folder. I am using the new Outlook Office 365. Any idea of what prevent me from getting the emails? I used my own email to receive all emails to test if it works well for me.
can this work with a dynamic excel? eg if that first sheet neesd to be filtered to show a different list of contacts, does it create any complications?
Great video. Quick question please, how do I check which outlook email account is linked to the Word document? I've tried email the merged document but it's not showing in any of my Outlook 'Sent' boxes. Thanks!
After completing all the process marge field also reflected but mail is not send to mail address or not send from my Outlook
That's strange, were you using the practice files I provided or were they different ones?
I double checked my list, and went through again, nope my outlook never sent etc… frustrating… I’m gonna give it rest
How would I keep it from adding extra line items when I have multiple fields to add across the database? For instance I have taxes, prices, totals, but all vary per document, my problem is that all of the fields that I add, even if they're blank, they add a break and even though there's no data there I end up with a 3 page document of blank space rather than just populating the specific fields when there is data present. Is there a way to optimize this?
What if I need to combine a mr and ms from separate rows in the spreadsheet to the same letter? The common denominator between them On the spreadsheet is the same letter reference code.
I would like to know if i need to attach a document in the mails, how can i do that??
Is it possible to Exclude contacts on a Excel list or would i have to create a new Excel Sheet that does not include the email?
In your word document, if you go to the Mailings header, and find the option that says "Edit Recipient List", you should be able to uncheck the checkboxes for the people you don't want to send an email to.
How would you format the “Today’s date” line?
How would you delay delivery of these emails? I am going to send out students' grades and I want to be off the school premises by the time they receive their results!
Can we also check the campaign performance? If yes, how?
Thank you!!!
Hi, is there limited users, need subscription for more users to send email or free for unlimited?
I want to mail merge parents with results of student's, however, I'm having trouble with the percentage column. eg. 60% How can you mail merge results?
Hi techer, good but can you help me why i couldn’t send out via my web outlook365? Even I switched my outlook 365 to windows base but still in vain. Could you pls help on this.
Thx
my emails are not sent. any comments appreciated.
Same issue, no luck so far
This has prevented me from kms
Well, I like your easy to understand teaching………here’s my problem……….why can’t i find MY Excel document headings?????????? I’m only seeing the preset headings in Word………I even tried to use their F1, F2, F3, etc and got nothing but blank documents. Windows 7 used to let me see my document headings!!!! Now I have 365 and am going to scream…………I hope you can help me before the top of my head pops off!!!!!!