Thank you for KISS = Keep it simple stupid. This is a helpful video to enable MM without using Outlook. You spoke clearly and it is easy to follow. Good job!
Excellent explained. How to move receivers address max move to Right side of envelope. Bcoz my country we used not in middle..have no option .max thank you
Again, you are awesome. THANK YOU! May I ask, do you have a tutorial for creating the source list of addresses in Excel? I have a file I would like to paste into Excel, and edit fields (if possible.) Thanks!
+Erin Kelly Hi Erin, I don't have a tutorial for that. But all you need to do is create an Excel file, save it, in the cells A1, B1, C1, etc enter your Field name, then fill up the information. You mentioned you have a file, what do you mean? Is it an Excel file with names etc. All the best.
+Amir Parmar My contact list was presented to me as a Word file. I assume I will have to cut and paste into Excel :/ thank you for the tips, re: formatting Excel. It was very helpful! Best, Erin
+Erin Kelly If the contact list in word is in a Table; you could copy paste all the contacts. Or else it will either typing or copying/pasting one at a time.
+Amir Parmar I am trying to use mail merge for A6 size envelopes. The issue I am having is for my return address, on the preview it show it in the proper position but when it prints, it prints more to the middle top of the envelope. I chose custom size of 6.5 and and 4.7 (closest to the actual 4.75 height). Do you have any suggestions to get the return address to print more to the left side of the envelope. I use HP 8625 printer
Hello and thank you for taking the time to upload video. I just installed the microsoft 365, and assumed is the same as 2016. I tried to do envelopes as you demonstrated in the last minute. Looks just like you did, however I see NO option to OMIT return address nor could I find one anywhere. All our envelopes are pre printed, Does anyone know how to do this? thank you
Amir Parmar Thanks for your response. I started "doing" the task but somehow I already have the names and addresses of people on a word document. So copy and paste each field is impossible and entering manually will take some time.. Could you send me the video of that you created your charity list on MS Access? Thanks.
In what format do you have the list in Word? Is it in some kind of table? When you use the Mail Merge Wizard and create the list through this process; the List can be opened in Access. Depending on the way your data is in Word, you could export it to Access or even copy/paste in Excel.
I will have to go watch the video to understand what you are asking about creating charity list in Access. In this video you will see at the start I use the "Create new List" button and I save this file. This file (data source) when opened will open in Access. I have a tutorial on creating Tables in Microsoft Access if you want to watch. But it might be easier to create the list in Excel. here is the access video link, hope this helps. Microsoft Access 2013 pt 1 (Tables)
Followed this tutorial and very easy to create the envelopes using mail merge, but the printer shows idle and will not print. after inserting all the envelopes. How to fix?