Hi Kevin. I have a problem. I have made a spreadsheet(xlsx) and made a simple table, and I made the template in docx. But when I did "Open data source", and select my spreadsheet, the app keeps saying "WPS cannot open data source" I tried searching the forum, but I haven't found any answers. can anyone help me? if you have a link to an article or forum discussion about this, that would be very helpful. thank you.
I have found the solution, Through trial and error Here's the solution After saving your excel file save it as wps spreadsheet which is .ett do not save as .xslx, .xsl because it will not work do not know why.
@@jeizn7711 Go to save as and there will be a fire explorer window that will let you customize the name and file type change the default which is .xslx to .ett
Hey Kevin I was looking at you or how to mail merge on WPS when I got to the end operation that you did it would not upload it says merge fail what did I do wrong
Thanks for the tutorial. The data source part is fine for me but now I'm stuck at the mailing part. Windows already defaulted Mail as the mailing program but when I pressed send nothing happened. I already set up my account as sender and linked the recipients's emails.
Could you please explain where the envelopes tab is and why it isn't there? The WPS site has only one page devoted to this subject but in my case nothing referenced in this article exists.
My WPS excel sheet came out with Compatibility issue, I don't know how to identify where it went wrong that it refused to save in the same excel sheet and wouldn't appear in the mail merge
Click Insert Merge Field to insert the Name field into the document. Place your cursor in the Picture bar and click Insert - Document Parts - Field. In the Document Parts pop-up window, select the domain name Insert Picture.
Hi. Came to your video after a few searches. After I click on the open mail source (the button to open the data source), it shows that WPS can't open the Data Source. How can I fix it? Please reply before Tomorrow 🙏🙏
The data source cannot be opened, generally the data source is being opened in exclusive mode or the word version is low, close the data source and try again
Hello Kevin,,,,,can you help me. I have a list of fifty email addresses and every so often i need to send them all the same message, from my webmail address. Question......How can i attach the message to my list of emails and send them all off. I am as green as grass and i have a feeling that the list is going to grow by a fair margin. very best regards Jim
Not out of the box as far as I'm aware. If you have Word and Excel, you can send attachments using a free add-in: ua-cam.com/video/yj_s3cdfVDY/v-deo.html
******************** For those getting the "WPS cannot open the Data source" ******************** You will be requested to download "Access Database". That doesn't work, period. The workaround is to create your data source (where you have the name, email, etc...) as CSV. Just select that format when you save your file. You will be able to open it as any other excel file (text only). Once you do that, open WPS and follow the steps shown on the video. No need of premium to set this up. Also: Make sure you send the message as HTML. For some reason, Gmail gets an attachment as winmail.dat so I ended up changing from plain text to HTML. My final recommendation: Don't use Outlook (If you have outlook, just use Word + Excel), use Thunderbird instead. It works just fine.
I don't have words. I strugled with my assignment whole day but this video helped me a lot
this totally helped me with my assignment, thank youuuu
Thx kevin, I'm looking for wps tutorial, you're one of few youtuber that make it. Keep it up
Hi Kevin. I have a problem. I have made a spreadsheet(xlsx) and made a simple table, and I made the template in docx.
But when I did "Open data source", and select my spreadsheet, the app keeps saying "WPS cannot open data source" I tried searching the forum, but I haven't found any answers.
can anyone help me? if you have a link to an article or forum discussion about this, that would be very helpful. thank you.
Same problem here
I have found the solution, Through trial and error Here's the solution After saving your excel file save it as wps spreadsheet which is .ett do not save as .xslx, .xsl because it will not work do not know why.
How to save it as .ett
@@jeizn7711 Go to save as and there will be a fire explorer window that will let you customize the name and file type change the default which is .xslx to .ett
@@jeizn7711 But I don’t recommend this solution if you want to send the soft copy to someone else because excel can’t read it
If you already have WPS and just want mail merge skip to 2:20
Thank you Kevin. It helps me a lot to process the letter in such a hurry
Thank you for this tutorial
Thanks! Helped me understand my lesson in school much easier
Hey Kevin I was looking at you or how to mail merge on WPS when I got to the end operation that you did it would not upload it says merge fail what did I do wrong
Thank you very much! This helped me in my academics.
Thanks - still got to work out some problems but very helpful
Thanks! You made this so easy to understand.
Excellent video tutorial Kevin. Very clearly presented. Thank you for your channel.
Thanks for the tutorial. The data source part is fine for me but now I'm stuck at the mailing part. Windows already defaulted Mail as the mailing program but when I pressed send nothing happened. I already set up my account as sender and linked the recipients's emails.
Thank you for explaining it so clearly.
How to turn off de text limits gide lines in WPS office? Thanks
1.Go to the "View" tab on the menu bar.
2.Look for an option named as "view gridlines".
3.Uncheck or deselect the option for text limits gridlines.
Thank you, I've been in pretty stressed because I didn't know how to do that.💙💜
Lovely. Is there a way of sending the attachments as PDF?
You can convert the document to pdf first
Could you please explain where the envelopes tab is and why it isn't there? The WPS site has only one page devoted to this subject but in my case nothing referenced in this article exists.
I'm having the same issue. Can't seem to find how to do this for envelopes.
Thanks, I was looking for a software like this
Do more on wps great job thanks
My WPS excel sheet came out with Compatibility issue, I don't know how to identify where it went wrong that it refused to save in the same excel sheet and wouldn't appear in the mail merge
Interesting Tutorial. Do you use the same method if you want to send an email as a Word Document and not as a PDF??
Thank you kevin this tutorial help me lot thank you soo much sir
I wanna do the mail merge to a bulk of employees and to include their managers in the CC as well
thankyou you helped a lot.
Thank you very much! But , how to insert pictures in WPS Office Mail Merge?
Click Insert Merge Field to insert the Name field into the document. Place your cursor in the Picture bar and click Insert - Document Parts - Field. In the Document Parts pop-up window, select the domain name Insert Picture.
Any Indian here ❓❓
Excellent Video but I can't seem to mail merge with WPS office to make envelopes for Christmas Cards happen.
Dear Kevin , can you please teach me how to insert check box or other options like that in wps writer or spreadsheet .....
It says, "WPS Writer cannot open the Data Source."
I love your accent 💚
Hi, why it says cannot open the data source when i try to open? Is there something i did wrong?
starts at 4:17
It is not for free. After installing the mail merge features are not available unless I chose the premium version.
i cannot use it, it says "WPS writer cannot open data source", how to fix this? help please.
nice. really helped
Im havubg some troubke, why cant my WPS Writer open my data source?
I appreciate it! Thanks
can I ask, why mine it's says "WPS cannot open the Data source"?
Hi. Came to your video after a few searches. After I click on the open mail source (the button to open the data source), it shows that WPS can't open the Data Source. How can I fix it? Please reply before Tomorrow 🙏🙏
Please help me 😭😭😭😭😭😭
How to use a different e-mail sender like Thunderbird?
Can this be done using a mobile phone??
anh ơi. Cho em hỏi là em mở Data Scoure nhưng khi em chọn File tệp khi mở File tệp File báo không mở được giờ em phải làm sao ạ
goof tutorial. thanks
What should I do. I try to open my spreedshet and it says “cannot open data source”
i have the same problem
help me !! I can't open nor insert the table on a document that I've been created. it says "WPS Writer canno open the Data Source" 😭😭😭
oh wait, I think I got it... I save the excel file with format .et 🗿 thanks btw
Hi Kevin. Can we put multiple email for each mail merge documents. Thanks
Anything would be helpful
How to save mail merged documents to different new files
Can i make a mail merge using a free version on WPS?
Thank you
Hi Kevin, I downloaded the Mac version. There's no option/feature for MailMerge though. Anyone can help?
i have it in a mac and the option is there. under the reference tab
Thanks😍😊
thank you so much
I tried this but always saying wps writer cannot open data souce
PERFECT CONTENT
hi, can anyone help me?
i tried to use mail merge feature but when i open the database (spreedsheet) it said "wps writer cannot open the data source"
The data source cannot be opened, generally the data source is being opened in exclusive mode or the word version is low, close the data source and try again
How to do mail merge on MacBook
Please help
Hey I can't may spreadsheet when Im trying to open it in data source please send some help buddy.
Same prob.
Same, help me
Sir how to mail merge in cellphone, thanks!
Can i attach documents? if so how?
I am getting a messages WPS Write cannon open the Data Source doing all right
Do you have tutorials for other WPS Office projects?
not yet. Are there any in particular that would be useful?
Hello Kevin,,,,,can you help me.
I have a list of fifty email addresses and every so often i need to send them all the same message, from my webmail address.
Question......How can i attach the message to my list of emails and send them all off.
I am as green as grass and i have a feeling that the list is going to grow by a fair margin.
very best regards Jim
Hi Kevin, does WPS show report when the mail is opened?
Hey Mathew, not out of the box, you’ll need to rely on your email software or some other mechanism to track opens
How do we make a donation?
How to u fix this" WPS Writer cannot open the Data Source "?
mine also does this huh please help uss
Did you find the solution to your problem? Because I've got the same problem.
"Cannot open data source" pls help
I have no laptop I need to mail merge it Mobile
❤️✔️Thanks man
What to do if it says cannot open data source?
Same prob
can we add attachment in wps mail merge.?
Not out of the box as far as I'm aware. If you have Word and Excel, you can send attachments using a free add-in: ua-cam.com/video/yj_s3cdfVDY/v-deo.html
How to insert Picture using Mail Merge?
the emails didn't arrive
this isnt working for me
My module brings me here
I'm going to guess WPS is stealing your email list. LOL.
********************
For those getting the "WPS cannot open the Data source"
********************
You will be requested to download "Access Database". That doesn't work, period.
The workaround is to create your data source (where you have the name, email, etc...) as CSV. Just select that format when you save your file. You will be able to open it as any other excel file (text only).
Once you do that, open WPS and follow the steps shown on the video. No need of premium to set this up.
Also: Make sure you send the message as HTML. For some reason, Gmail gets an attachment as winmail.dat so I ended up changing from plain text to HTML.
My final recommendation: Don't use Outlook (If you have outlook, just use Word + Excel), use Thunderbird instead. It works just fine.
Tq
there is no email program wtf
Kevin Stratvert
Hindi version is needed here
How to brush my teeth
Thanks, I was looking for a software like this
Thank you so much
They ask me to set toinstall email program or set defaul email from panel....How To do i tried best but i cant
Sir how to mail merge in cellphone, thanks!
They ask me to set toinstall email program or set defaul email from panel....How To do i tried best but i cant
Sir how to mail merge in cellphone, thanks!