vba to send msg on whatsapp

Hello ,
i have a list of customer codes with mobile numbers and i have created a vba (you can find it below) to send a text msg to every customer after i open whatsapp web and this is working great but i have two issues with this vba
1- i need to attach a pdf file which on my pc
2- if i don't have the customer number in my contact list i need to ignore this number and continue (if there is a solution to send anyway it will be great)

and this is the vba

Sub Send()
Worksheets(2).Activate
Dim lrow As Long
lrow = Cells(Rows.Count, 1).End(xlUp).Row
For Each myCell In Worksheets(2).Range("A1:A" & lrow).Cells
Worksheets(1).Activate
Worksheets(1).Range("A1") = myCell.Value
Dim text As String
Dim contact As String
text = Range("C1").Value
contact = Range("A2").Value
Fazer (3000)
Call SendKeys("{TAB}", True)
Fazer (1000)
Call SendKeys(contact, True)
Fazer (1000)
Call SendKeys("~", True)
Fazer (1000)
Call SendKeys(text, True)
Fazer (1000)
Call SendKeys("~", True)

startrow = startrow + 1

Next myCell
End Sub
Function Fazer(ByVal Acao As Double)
Application.Wait (Now() + Acao / 24 / 60 / 60 / 1000)
End Function

Any Help????

Hello, is more easy to add all the number to yours contacts and to put the pdf in one url file, send your file to your cloud and share the link of the file with the text.
With this metode you don't duplicate any file in your mobile. Valid to pdf or photo or video...anything.

Originally Posted by eulices31

Hello, is more easy to add all the number to yours contacts and to put the pdf in one url file, send your file to your cloud and share the link of the file with the text.
With this metode you don't duplicate any file in your mobile. Valid to pdf or photo or video...anything.

Dear : eulices31 thank you,
a different pdf should be sent to every customer so i need to attach it from my pc
i did it already with outlook mail but i can't do this using what'sapp

so sorry, the idea than i have is...
For send different documents is better to upload this everyone in one server (for example drive) and later to send with the url of every document to every client.

if you resolv this problem...let my know please.

I have see programs to send automatic archives and text in whatsapp but don't see for multiples document.

Originally Posted by eulices31

so sorry, the idea than i have is...
For send different documents is better to upload this everyone in one server (for example drive) and later to send with the url of every document to every client.

if you resolv this problem...let my know please.

I have see programs to send automatic archives and text in whatsapp but don't see for multiples document.

the issue is more complicated because this macro is a part of another macro that makes payment request for every customer (when i change the customer code , the payment request figures changes ) then it is saved as pdf named with the same customer code after that i need to send it to the customer on what'sapp

And don't interest to program this option in PHP or other system?

Originally Posted by eulices31

And don't interest to program this option in PHP or other system?

Realy , i don't know